View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
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.


This seems to work...

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

Rick