The + operator returns #VALUE if either of its arguments are Text.

In article ,
crimsonkng wrote:

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