Hidding #DIV/0! In Cell

[Guest]

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.

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

how about

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

or

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

 

[T. Valko]

Try this:

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

Biff