Div/0

[Guest]

I have a formula in a cell that sums up some cells and then divides by
another cell. Staff will be entering data on each row, so I copied the
formula down the entire column. So now in each cell it shows #DIV/0!...this
is showing because none of the cells in the row have been populated yet. Is
there a way to hide the formula in the cell so that the users don't see
#DIV/0! when the row has not been used yet?

 

[Guest]

Instead of something like
=A1/B1
use
=IF(B1=0,"",A1/B1)

 

[Guest]

Thank you Gary, I will give that a try!