Hidding #DIV/0! In Cell
 

I am working on a form where I am putting formulas in order for other users
of the the form can plug in numbers and they can get a sum. The formula is
=(c19/c18) and until numbers are placed in the cells mentioned, there will be
"#DIV/0!". How would I hide this without hiding the sum for the formula when
numbers are entered into those cells.

Hidding #DIV/0! In Cell
 

I am working on a form where I am putting formulas in order for other users
of the the form can plug in numbers and they can get a sum. The formula
is
=(c19/c18) and until numbers are placed in the cells mentioned, there will
be
"#DIV/0!". How would I hide this without hiding the sum for the formula
when
numbers are entered into those cells.

This seems to work...

=IF(ISERR(C19/C18),"",C19/C18)

Rick

Hidding #DIV/0! In Cell
 

how about

=if(c18=0,"",c19/c18)

or

=if(iserror(c19/c18),"",c19/c18)


"Xena_Peel" wrote:

I am working on a form where I am putting formulas in order for other users
of the the form can plug in numbers and they can get a sum. The formula is
=(c19/c18) and until numbers are placed in the cells mentioned, there will be
"#DIV/0!". How would I hide this without hiding the sum for the formula when
numbers are entered into those cells.

Hidding #DIV/0! In Cell
 

Try this:

=IF(C18=0,"",C19/C18)

Biff

"Xena_Peel" wrote in message
...
I am working on a form where I am putting formulas in order for other users
of the the form can plug in numbers and they can get a sum. The formula
is
=(c19/c18) and until numbers are placed in the cells mentioned, there will
be
"#DIV/0!". How would I hide this without hiding the sum for the formula
when
numbers are entered into those cells.