IFERROR for #DIVIDE BY ZERO

Hi!

I'm calculating the averaged RYG in parent rows that's tied to our Status column. Until the status changes to something other than "Not Started", the parent row displays #DIVIDE BY ZERO. I'm trying to use IFERROR to display blank but I'm getting an #INCORRECT ARGUMENT SET. I'm probably missing a parenthesis somewhere.

Here's my formula:

=IFERROR(IF((COUNTIF(CHILDREN(), "Yellow") + (COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 0.1, "Green", IF((COUNTIF(CHILDREN(), "Yellow") +(COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 1.5, "Yellow", IF((COUNTIF(CHILDREN(), "Yellow") + (COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 2.5, "Blue", "Ideal", ""))))


Any help is appreciated!

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    IFERROR does work for #DIVIDE BY ZERO. Your parenthesis are just off there at the end.


    =IFERROR(IF((COUNTIF(CHILDREN(), "Yellow") + (COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 0.1, "Green", IF((COUNTIF(CHILDREN(), "Yellow") +(COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 1.5, "Yellow", IF((COUNTIF(CHILDREN(), "Yellow") + (COUNTIF(CHILDREN(), "Blue") * 2)) / COUNT(CHILDREN()) <= 2.5, "Blue", "Ideal"))), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!