IF THEN

E

eric

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
 
P

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 woul
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
Click to expand...

Hi Eric

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

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

JE McGimpsey

Your statement is pretty general, but perhaps something like:

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

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
 
Top