Hidding #DIV/0! In Cell

X

Xena_Peel

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.
 
R

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.
Click to expand...

This seems to work...

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

Rick
 
Top