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

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

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

--
Regards

Roger Govier


"Clark" <[email protected]> wrote in message
news:[email protected]...
> 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

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Clark" <[email protected]> wrote in message
news:[email protected]...
> 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

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

"Bob Phillips" wrote:

> =IF(E5="choice1","T","D")
>
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Clark" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

Hi Clark

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

--
Regards

Roger Govier


"Clark" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> "Bob Phillips" wrote:
>
>> =IF(E5="choice1","T","D")
>>
>>
>> --
>>
>> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from the email address if mailing direct)
>>
>> "Clark" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>