Hi Norman

Try...

=IF(ISNUMBER(SEARCH("test",A30,1)),"Yes","No")



"Norman K via OfficeKB.com" wrote in message
...
Hi
I use wildcards for =countif function and it works
but when I use it with for example =if(b30="*test", "yes", "no") it always
gives me a "no" in the cell.
if in include the asterisk in the B30 cell the if is successful.
what am i doing wrong?
Regards
Norman


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1