Using IF formula to show what text is in the cell from ddown list

C

Clark

Here is what I need to accomplish:

In cell A1, I want a formula to read another cell, say E5.
Cell E5 is a drop down list with only two choices
If it is choice one, then I want cell A1 to display a "T"
If it is choice two, then I want cell A1 to display a "D".

I am trying to figure out the right combination of ISTEXT and IF statements
to make this work.

Clark
 
R

Roger Govier

Hi Clark

One way
=IF (E5="choice one","T","D")
Substitute for "choice one" whatever is the first value in your 2
available choices for cell E5
 
B

Bob Phillips

=IF(E5="choice1","T","D")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
C

Clark

Thanks Guys, I figured it out and it reads:

=IF(('Jan 07'!E8="Tentative"),"T",IF(('Jan 07'!E8="Definite"),"D",""))

That way it stays blank if nothing is chosen on the list.

Clark
 
R

Roger Govier

Hi Clark

That being the case, then it can be made even simpler, with no IF's
required
=LEFT('Jan O7'!E8)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top