How to eliminate Divide by Zero error from IF formula
Jed Rusyniak
✭✭✭✭
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.
Comments
-
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
