ExcelBanter

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/143878-re-hidding-div-0-cell.html)

Harlan Grove[_2_]

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,"")



All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com