Conditional/Nested Formula

[Kuliano]

I have a drop down list in B3 with three (text) values - call then a, b, and,
c. Based on what a user selects in the drop down, I need to perform other
calculations:

If B3 = "a", I want to populate E3 with 0, or
If B3 = "b", I want to populate E3 with 1, or
If B3 = "c", I want to populate E3 with 2

I'm at a loss...

 

[Adilson Soledade]

In E3 you must write the formula: =IF(B3="a",0,IF(B3="b",1,2))

 

[Teethless mama]

=CODE(LOWER(B3))-97

 

[Tyro]

In E3 put: =IF(B3="a",0,IF(B3="b",1,IF(B3="c",2,""))) This formula will
return a 0 if B3 is "a", a 1 if B3 is "b", a 2 if B3 is "c" and an empty
string if B3 is not "a", "b" or "c". Note the formula is not case sensitive.
That is, "A" is equal to "a". I suggest you obtain a good book on Excel by
an author such as John Walkenbach.
http://j-walk.com/ss/ He has written Excel 2003 Bible and Excel 2007 Bible
among his many books. The books cost about $40 (U.S.) and are easy reading.

Tyro

 

[Mike H]

and another

=CHOOSE(CODE(LOWER(B3))-96,0,1,2)

Mike