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

"Rick Rothstein \(MVP - VB\)" wrote...
....
This seems to work...

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


You could be hiding meaningful errors this way. Such as #NAME? or
#REF! errors. All you should do is avoid division by zero. All that
requires is testing whether the denominator is zero.