wildcards do not seem to work

  • Thread starter Thread starter Norman K via OfficeKB.com
  • Start date Start date
N

Norman K via OfficeKB.com

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
 
Hi Norman

Try...

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



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
 
But you can use =countif() with a single cell:

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