Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
