![]() |
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