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