Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hopefully, this is the correct forum in which to ask this question.
In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |