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

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

Hi Eric

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

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=444856

Your statement is pretty general, but perhaps something like:

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

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

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


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