But you can use =countif() with a single cell:

=if(countif(b30,"*test")0,"Yes","No")

"Norman K via OfficeKB.com" wrote:

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

--

Dave Peterson