| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF question
By nesting a SEARCH function inside the IF, you can do what you need:
=IF(SEARCH("office",AC21,1)0,"Yes","No") SEARCH looks for the string "office" in cell A21 and returns its position in the string if it is there, or zero if it is not. SEARCH is similar to FIND, but SEARCH is not case sensitive, where FIND looks for an exact case match. Have a good weekend! Dave O |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| question. | New Users to Excel | |||
| an if question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Threaded Mode
