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