Share via

How to nest the IFERROR function around a formula

Anonymous
2010-11-07T03:56:07+00:00

I have a formula  =sum(C15-C16)/C17  The formula works but when there are not numbers in the cells in the worksheet I get an error value.  How do I nest the IFERROR function around that formula?

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-11-07T04:39:45+00:00

    I have a formula  =sum(C15-C16)/C17  The formula works but when there are not numbers in the cells in the worksheet I get an error value.  How do I nest the IFERROR function around that formula?

    Thanks!

    Try this:

    =IFERROR(SUM(C15-C16)/C17),"what you want instead of the error")

    or just

    =IFERROR((C15-C16)/C17),"what you want instead of the error")

    Hope this helps / Lars-Åke

    20+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2010-11-07T14:52:41+00:00

    I have a formula  =sum(C15-C16)/C17  The formula works but when there are not numbers in the cells in the worksheet I get an error value.  How do I nest the IFERROR function around that formula?

    Thanks!

    Try one of these...

    To leave the cell blank:

    =IFERROR((C15-C16)/C17,"")

    =IF(C17="","",(C15-C16)/C17)

    To return 0:

    =IFERROR((C15-C16)/C17,0)

    =IF(C17="",0,(C15-C16)/C17)

    --

    Biff

    Microsoft Excel MVP

    1 person found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2015-09-11T23:37:12+00:00

    Hi,

    Try this

    =IFERROR(VLOOKUP(D2,'IM file'!C:AB,25,0),"")

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2010-11-08T01:39:59+00:00

    Hi,

    You may also try this

    =if(iserror((C15-C16)/C17),””,(C15-C16)/C17)

    Regards,

    Ashish Mathur

    Microsoft Excel MVP

    www.ashishmathur.com

    "An Old Student" wrote in message news:1e066b14-e101-4131-8f19-8001299a4e87...

    I have a formula  =sum(C15-C16)/C17  The formula works but when there are not numbers in the cells in the worksheet I get an error value.  How do I nest the IFERROR function around that formula?

    Thanks!

    Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

    0 comments
  3. Anonymous
    2010-11-07T19:16:17+00:00

    The first one worked perfectly, thanks!!

    S

    0 comments