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
|