IF - looking in a cell for a specific value
=IF(NOT(ISERROR(FIND("fred",A2))),"Yes","No")
or
=IF(ISERROR(FIND("fred",A1)),"No","Yes")
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Sarah (OGI)" wrote in message ...
| In an IF statement, what do I need to write to say that if cell A1 contains
| "fred", (i.e. " * fred * ") then.. "Yes".
| (I'm not sure what operator is needed to say 'contains')
|
| Any ideas?
|