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

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)