View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Hidding #DIV/0! In Cell

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.


First off, your formula is a ratio, not a sum.

Next, #DIV/0! errors caused by blank cells are better handled in the
formula than by formatting. Change your formula to

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