IF statements

[turpin_1980]

Not really sure what to use. I'm trying to look at one cell (A1) and if it contains a certain work or phrase then another cell (B2) is true.

[XOR LX]

Hi,

Depends what you mean by "contains". If you mean that the entry in cell A1 matches precisely your phrase, then, in B2 enter:

=IF(A1="This Phrase",TRUE)

If you mean that cell A1 contains your phrase somewhere within its string, then, in B2:

=IF(ISNUMBER(SEARCH("This Phrase",A1)),TRUE)

Regards