| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make Search formula evaluate to blank
I am using Office 2003 on Windows XP.
I have the following formula, which works: =IF(SEARCH("*Option*",G2, 1)=1,N2*E2*F2,"") However, when the search text (Option) is not found, this function evaluates to the "#VALUE!" error. How can I alter this function so that if search text is not found, 1) a blank will result; 2) as another option so that a Zero will result... Thanks much in advance for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I have a formula in a cell, how can I make it come up blank? | Excel Discussion (Misc queries) | |||
| how to make a formula ignore blank cells | Excel Worksheet Functions | |||
| How to evaluate a blank field | Excel Programming | |||
| can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
Threaded Mode
