Results 1 to 7 of 7

Help preventing N/A errors

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    Help preventing N/A errors

    Hello,

    The following array formula works perfectly:
    Formula: copy to clipboard
    =IF(AND(ISNUMBER(MATCH(I2,{"Apple","Banana","Orange"},0)),MATCH("Happy",$I3:$I$240000,0)<MIN(IFERROR(MATCH({"Apple","Banana","Orange"},$I3:$I$240000,0),10^10))),IF(MATCH("Happy",$I3:$I$240000,0)>MIN(IFERROR(MATCH({"Expensive"},$AB3:$AB$240000,0),10^10)),"No Bingo","Yes Bingo"))


    however, after the last row where the condition takes place, it just gives N/A errors from then on.
    what can i do to the formula to give a blank cell instead of the N/A error? but everything else works the same.

    also, "no bingo" is never displayed anyway. a FALSE is there instead. was wondering why this is. is there any need of it being in the formula above?


    thank you.
    Last edited by tlacloche; 05-09-2014 at 12:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Preventing the display of divide by zero errors.
    By Determined in forum Excel General
    Replies: 6
    Last Post: 04-18-2007, 09:58 PM
  2. [SOLVED] Excel Throwing Circular Errors When No Errors Exist
    By MDW in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2006, 09:20 AM
  3. Preventing Duplicates
    By Ed in forum Excel General
    Replies: 11
    Last Post: 05-31-2006, 11:00 PM
  4. Preventing errors
    By koit in forum Excel General
    Replies: 7
    Last Post: 02-21-2006, 07:20 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1