Text, huh? Hmmmm, that's odd. I didn't realize that I had text in those
cells. OK, I'll take a look. Thanks for your help.

Dan

"JE McGimpsey" wrote:

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