what is the best way to get rid of #DIVIDE BY ZERO ?

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

Atus Bartal

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

J. Craig Williams

Try IFERROR()

https://help.smartsheet.com/function/iferror

Craig