wildcards do not seem to work
 

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

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

Thanks KK it works

Regards

Norman
kk wrote:
Hi Norman

Try...

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



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

You're welcome!.


"Norman K via OfficeKB.com" wrote in message
...
Thanks KK it works

Regards

Norman
kk wrote:
Hi Norman

Try...

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



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

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