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.

If you name your formula "MyFormula", use it in one of the error
functions such as:

IF(ISERROR(MyFormula)=TRUE,"",MyFormula)

See help for all the Error functions available.

For a zero, replace the "" with 0.