Forum Discussion

Copper Contributor

Apr 06, 2018

Excel Formula Help

Hoping someone can help. I'm trying to write a formula for the following example: Cell A1 will have A,B,or C entered. Cell D1 will have a number (let's say 5) Cell E1 formula: if A1 is A then ...

Excel Desktop

Formulas & Functions

Haytham Amairah

Silver Contributor

Apr 06, 2018

Hi Jamie,

This is the correct syntax of the formula which is called (Nested IF):

=IF(A1="A",D1*3,IF(A1="B",D1*4,IF(A1="C",D1*5,0)))

NOTE: If the cell A1 doesn't contain A, B, or C, the formula will return 0.

Hope that helps

Haytham

Jamie Swan

Copper Contributor

Apr 06, 2018

Thank You! I was making the formula more complex than it needed to be. Thanks Again!

Jamil
Bronze Contributor
Apr 06, 2018
While Haytham solution works for you.

here are another two ways you can achieve the same result. simplified =D1*IF(A1="A",3,IF(A1="B",4,IF(A1="C",5,0)))

and with VLOOKUP

=D1*IFERROR(VLOOKUP(A1,{"A",3;"B",4;"C",5},2,0),0)