Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
what is the best way to get rid of #DIVIDE BY ZERO ?
Options
Jef Forward
✭✭✭✭
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you,
Jef
Comments
-
Jef,
I don't know if this is the best way, but certainly the easiest one:
=IF(Number1 <> 0, 1 / Number1, "")
It checks if the value of the cell (in this case in the first row in "Number" column) is 0 or not. If not, it divides 1 by the given value, if zero, it leaves the cell blank.
Atus
-
This discussion has been closed.
