IF THEN

[eric@innerlith.com]

Hi all,

Can an IF statement be written referencing a text value? My situation
is this I have created a list with different text values. I would like
the statement to check for these values in the list cell THEN once the
criteria are met apply the rest of the formula. If somebody knows a
different way to do this I will take any suggestions.


Thanks,

Eric H

[Paul Sheppard]

Hi all,

Can an IF statement be written referencing a text value? My situation
is this I have created a list with different text values. I would like
the statement to check for these values in the list cell THEN once the
criteria are met apply the rest of the formula. If somebody knows a
different way to do this I will take any suggestions.


Thanks,

Eric H

Hi Eric

Yes you can reference text in an IF statement, it needs to be enterred as "Text"

eg IF(C3="text",x,y)

[JE McGimpsey]

Your statement is pretty general, but perhaps something like:

=IF(OR(A1="apple",A1="banana",A1="cherry"),<rest of formula>,"")

In article <1126039812.760465.46700@f14g2000cwb.googlegroups.com>,
eric@innerlith.com wrote:

> Hi all,
>
> Can an IF statement be written referencing a text value? My situation
> is this I have created a list with different text values. I would like
> the statement to check for these values in the list cell THEN once the
> criteria are met apply the rest of the formula. If somebody knows a
> different way to do this I will take any suggestions.
>
>
> Thanks,
>
> Eric H

[CLR]

If your list of criteria text is very long, or the "rest of the formula"
varies depending on the criteria, then consider using the VLOOKUP function.

Vaya con dios,
Chuck, CABGx3


<eric@innerlith.com> wrote in message
news:1126039812.760465.46700@f14g2000cwb.googlegroups.com...
> Hi all,
>
> Can an IF statement be written referencing a text value? My situation
> is this I have created a list with different text values. I would like
> the statement to check for these values in the list cell THEN once the
> criteria are met apply the rest of the formula. If somebody knows a
> different way to do this I will take any suggestions.
>
>
> Thanks,
>
> Eric H
>