View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xena_Peel Xena_Peel is offline
external usenet poster
 
Posts: 1
Default 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.