IF - looking in a cell for a specific value
Try is with
=IF(SEARCH("fred";A1)0;"YES";"NO")
greetz
"Sarah (OGI)" schreef in bericht
...
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?
|