IF - looking in a cell for a specific value
On Nov 30, 10:15 pm, Sarah (OGI)
wrote:
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?
=IF(COUNTIF(A1,"*fred*")0,"Yes","No")
Ken Johnson
|