| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you use multiple SEARCH functions in one cell
Hi,
I'm trying to write a complicated equation and I need it to search 2 different cells for the word "Sunday". I'm trying to put both in an IF equation, but they won't both work properly. Here's my example: =IF(SEARCH("SUNDAY",D28),"",IF(SEARCH("SUNDAY",D25 ),Z23+1,"")) In the above equation, the first function works and leaves the cell blank, but if the search for "Sunday" is FALSE it returns a #Value! error. ....any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple functions on one cell ? | Excel Discussion (Misc queries) | |||
| Multiple functions in a cell help | New Users to Excel | |||
| MUltiple functions on a same cell | Excel Discussion (Misc queries) | |||
| Multiple functions per cell? | Excel Worksheet Functions | |||
| Multiple functions in one cell | Excel Worksheet Functions | |||
Threaded Mode
