How to eliminate Divide by Zero error from IF formula

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

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
    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,