Div/0
 

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?
--
Deb G

Div/0
 

Instead of something like
=A1/B1
use
=IF(B1=0,"",A1/B1)
--
Gary''s Student
gsnu200703


"Deb G" wrote:

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?
--
Deb G

Div/0
 

Thank you Gary, I will give that a try!
--
Deb Geambazi


"Gary''s Student" wrote:

Instead of something like
=A1/B1
use
=IF(B1=0,"",A1/B1)
--
Gary''s Student
gsnu200703


"Deb G" wrote:

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?
--
Deb G