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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Clark - 24 May 2006 22:57 GMT

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

Reply to this Message

Roger Govier - 24 May 2006 23:28 GMT

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

Signature

Regards

Roger Govier

> Here is what I need to accomplish:
>
[quoted text clipped - 8 lines]
>
> Clark

Reply to this Message

Bob Phillips - 24 May 2006 23:31 GMT

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> Here is what I need to accomplish:
>
[quoted text clipped - 7 lines]
>
> Clark

Reply to this Message

Clark - 24 May 2006 23:39 GMT

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

> =IF(E5="choice1","T","D")
>
[quoted text clipped - 18 lines]
> >
> > Clark

Reply to this Message

Roger Govier - 25 May 2006 08:19 GMT

Hi Clark

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

Signature

Regards

Roger Govier

> Thanks Guys, I figured it out and it reads:
>
[quoted text clipped - 26 lines]
>> >
>> > Clark

Reply to this Message