| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Erase & Draw Border functions no longer work | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
| Service work order | Charts and Charting in Excel | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
