#DIVIDE BY ZERO Error - other resolutions not working

edited 03/24/22 in Formulas and Functions

I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using:

=ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0)

I tried the IFERROR(ROUNDUP resolution and that gave me an invalid argument.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!