ExcelBanter - Hidding #DIV/0! In Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hidding #DIV/0! In Cell (https://www.excelbanter.com/excel-worksheet-functions/143888-re-hidding-div-0-cell.html)

Harlan Grove[_2_]

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.

All times are GMT +1. The time now is 08:18 AM.