why am I getting a #VALUE! error?
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
|