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
|