| 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 |
| 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 | |||
Threaded Mode
