+ Reply to Thread
Results 1 to 2 of 2

Make Search formula evaluate to blank

  1. #1
    XP
    Guest

    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.

  2. #2
    JakeyC
    Guest

    Re: Make Search formula evaluate to blank

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts