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
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
Try IFERROR()
https://help.smartsheet.com/function/iferror
Craig