Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding formulars used in a worksheet | Excel Worksheet Functions | |||
Hidding the formula and limiting users | Excel Discussion (Misc queries) | |||
Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
Hidding Tabs | Excel Discussion (Misc queries) |