Conditional/Nested Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kuliano - 18 Mar 2008 20:15 GMT

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...

Reply to this Message

Adilson Soledade - 18 Mar 2008 20:21 GMT

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

Signature

Adilson Soledade

> 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
[quoted text clipped - 5 lines]
>
> I'm at a loss...

Reply to this Message

Teethless mama - 18 Mar 2008 20:29 GMT

=CODE(LOWER(B3))-97

Reply to this Message

Tyro - 18 Mar 2008 20:43 GMT

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

>I have a drop down list in B3 with three (text) values - call then a, b,
>and,
[quoted text clipped - 6 lines]
>
> I'm at a loss...

Reply to this Message

Mike H - 18 Mar 2008 20:50 GMT

and another

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

Mike

Reply to this Message