Announcement

Collapse
No announcement yet.

ISERROR- Too many arguments

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ISERROR- Too many arguments



    Hello all,

    I am attempting to place the following function into an excel cell; however, I am told that their are too many arguments in the function.

    Here is the function:=IF(ISERROR(M12/SUM(E12:I12),0, M12/SUM(E12:I12))

    Is this possible? If so, what changes do I make?

    Thanks a ton!

  • #2


    Looks like a missing closing bracket..

    =IF(ISERROR(M12/SUM(E12:I12)),0, M12/SUM(E12:I12))

    or try instead:

    =IFERROR(M12/SUM(E12:I12),0)
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    MS Excel MVP 2010-2016

    I am participating in the "Walk for a Cure" for the Kidney Foundation of Canada. If you can/want to, please Donate: https://kidney.akaraisin.com/ui/1674...cipant/1145052

    Comment

    Working...
    X