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. 

 

 

sean59916

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