Conditional/Nested Formula
 

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

Conditional/Nested Formula
 

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


"Kuliano" wrote:

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

Conditional/Nested Formula
 

=CODE(LOWER(B3))-97


"Kuliano" wrote:

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

Conditional/Nested Formula
 

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



"Kuliano" wrote in message
...
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...

Conditional/Nested Formula
 

and another

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

Mike

"Kuliano" wrote:

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