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.