Thread: IF function

Hi all,

Is there anyway to incorporate a wildcard funtion into an IF function?

What I was planning on doing is something along the lines of


a b c
1 alan smith
2 john smith
3 graeme grey

what id like to do is
if(a1=*"smith"....)
but can't work out how?

is there anyway to use a wildcard in functions?

THanks

Hi,

This formula should be ok for what you want :

=IF(ISERROR(FIND("smith";A1));"Found";"Not found")

(depending on your language settings, replace the <;> by <,>)


Bye