Hidding #DIV/0! In Cell
 

another idea is to leave the formula as it is, and use conditional
formatting to turn it to white text if it's an error..........

formula is if(iserror(c19/c18))
format white text

then it'll automatically be "invisible" when people open the
spreadsheet, but when they start entering info into column c then
suddenly the formula will "appear".

:)
susan


On May 23, 1:34 pm, 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.