#DivideByZero error
Options
BESP10
✭✭✭✭✭✭
I am trying to use this formula so I dont get the #DivideByZero error but it is giving me this pop up, what is wrong with my syntax?
=IFERROR([% Comp.]@row/HTD@row),0)
I get this pop up
Thanks
Best Answer
-
try adding brackets around the HTD:
=IFERROR([% Comp.]@row / [HTD]@row, 0)
Answers
-
try adding brackets around the HTD:
=IFERROR([% Comp.]@row / [HTD]@row, 0)
-
AHHHH
THANK YOU !!😀
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!