+ Reply to Thread
Results 1 to 2 of 2

Nested IFERROR

  1. #1
    Forum Contributor
    Join Date
    10-28-2014
    Location
    Sydney
    MS-Off Ver
    Professional 2010
    Posts
    151

    Nested IFERROR

    Can some please help me with this.

    =IF(A3="","",IF(IFERROR(DK28,0,),IF(BC3=0,DK28,DK3/MAX(DK2:DK26))*FV24))

    Im wanting it to return a 0 if cell DK28 is a #DIV/0 error.

    thanks,

  2. #2
    Forum Contributor
    Join Date
    10-28-2014
    Location
    Sydney
    MS-Off Ver
    Professional 2010
    Posts
    151

    Re: Nested IFERROR

    Its OK, I worked it out.

    =IF(A3="","",IF(ISERROR(DK28),0,IF(BC3=0,DK28,DK3/MAX(DK2:DK27))*FV24))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IFERROR and nested ISERROR with different error messages or non at all
    By metalray in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 11:16 AM
  2. [SOLVED] nested iferror
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 02-28-2014, 03:06 PM
  3. [SOLVED] Trying to wrap a nested if(vlookup) statement in an IFerror
    By Groovicles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2014, 01:00 PM
  4. nested iferror index match for 10k rows
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2014, 12:46 PM
  5. Use of nested IFERROR or other suitable functions
    By kyjae in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 08:26 AM
  6. Nested IF and IFERROR
    By Richard N in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-16-2013, 03:42 PM
  7. [SOLVED] Nested iferror
    By corinereyes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2012, 01:21 PM
  8. IFERROR in a Nested IF function
    By hysterical_oliver in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2010, 06:38 AM

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