How to eliminate Divide by Zero error from IF formula

Jed Rusyniak · 05/09/19

I have a "Divide by Zero" error that I can't seem to get rid of.

=IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3)

Not sure where to place the IFERROR into this formula to ensure that I don't get the error to pop up.

Screen Shot 2019-05-09 at 6.55.42 PM.png

sean59916 · 05/10/19

Hi Jed,

Place the IFERROR at the front, i.e.

=IFERROR(IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3), "")

This will replace the error message with null.

I hope this helps,

Sean

Comments