Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I dont know how to fix it :) in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12) In Cell H12 is a formula that is dependent on another cell for information so its empty except for the formula When information is placed in the cell H12 the "#Value!" error goes away and it does its job How do I hide that "#Value!" until the time when information is placed in H12 I hope I explained the situation correctly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Format Cell | Excel Discussion (Misc queries) | |||
##### error in a cell | Excel Discussion (Misc queries) | |||
ERROR: Too many cell formats | Excel Discussion (Misc queries) | |||
Cell C1 ="error" if.... | Excel Worksheet Functions | |||
#### error if cell has more than 255 characters | Excel Discussion (Misc queries) |