+ Reply to Thread
Results 1 to 3 of 3

#VALUE! - Removal

  1. 04-08-2009, 03:35 AM #1
    garry1503
    garry1503 is offline
    Registered User
    Join Date
    10-14-2008
    Location
    London
    Posts
    10

    #VALUE! - Removal

    I have performed a =SEARCH function to find a character string. Where this criteria is not met, a return of #VALUE! is the result. Can anybody please advise how I make such a return to be blank or even "0" as I wish to perform a sum on the results?

    Many thanks.
    Reply With QuoteRegister To Reply
  2. 04-08-2009, 03:45 AM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: #VALUE! - Removal

    Hi Garry,

    A quick way is to surround your SEARCH function with an IF statement and error check like this:

    Please Login or Register  to view this content.
    HTH
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 04-08-2009, 04:01 AM #3
    garry1503
    garry1503 is offline
    Registered User
    Join Date
    10-14-2008
    Location
    London
    Posts
    10

    Re: #VALUE! - Removal

    Thanks very much - just what I wanted.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1