SOLVED

Excel Formula Help - Add specific value based on cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-1830302%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%20-%20Add%20specific%20value%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830302%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20some%20help%20with%20building%20a%20formula.%20I've%20provided%20a%20more%20basic%20example%20of%20what%20I%20need%20below.%3C%2FP%3E%3CP%3EI%20want%20to%20complete%20Column%20C%2C%20by%20adding%20a%20certain%20value%20to%20Column%20B%2C%20depending%20on%20the%20content%20of%20Column%20A.%3C%2FP%3E%3CP%3EIf%20A1%20%3D%20Up%2C%20I%20want%20C1%20to%20be%201000%2B50%3C%2FP%3E%3CP%3EIf%20A1%20%3D%20Down%2C%20I%20want%20C1%20to%201000%2B100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20reasons%20not%20worth%20going%20into%2C%20I%20don't%20want%20to%20use%20a%20formula%20which%20references%20back%20to%20a%20cell%20containing%20either%20%2250%22%20or%20%22100%22.%20I%20want%20to%20build%20a%20formula%20which%20includes%20the%20%2250%22%20or%20%22100%22%20values%20in%20the%20formula%20itself.%3C%2FP%3E%3CP%3EBut%20this%20is%20beyond%20my%20expertise%2C%20and%20I've%20not%20been%20able%20to%20make%20it%20work.%20I%20would%20appreciate%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SeanM365_0-1603933693445.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229999iFB0DBE01F3ED1A74%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SeanM365_0-1603933693445.png%22%20alt%3D%22SeanM365_0-1603933693445.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1830302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830424%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%20-%20Add%20specific%20value%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849701%22%20target%3D%22_blank%22%3E%40SeanM365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20simply%20try%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20C1%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DB1%2BIF(A1%3D%22Up%22%2C50%2CIF(A1%3D%22Down%22%2C100%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830426%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%20-%20Add%20specific%20value%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830426%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3EThis%20worked%20perfectly%2C%20thank%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello all,

 

Would appreciate some help with building a formula. I've provided a more basic example of what I need below.

I want to complete Column C, by adding a certain value to Column B, depending on the content of Column A.

If A1 = Up, I want C1 to be 1000+50

If A1 = Down, I want C1 to 1000+100

 

For reasons not worth going into, I don't want to use a formula which references back to a cell containing either "50" or "100". I want to build a formula which includes the "50" or "100" values in the formula itself.

But this is beyond my expertise, and I've not been able to make it work. I would appreciate any help.

 

SeanM365_0-1603933693445.png

 

3 Replies
Highlighted
Best Response confirmed by SeanM365 (New Contributor)
Solution

@SeanM365 

You may simply try this...

 

In C1

=B1+IF(A1="Up",50,IF(A1="Down",100,0))

and then copy it down.

 

Highlighted

@Subodh_Tiwari_sktneerThis worked perfectly, thank you.  

Highlighted

You're welcome @SeanM365! Glad it worked as desired.