why am I getting a #VALUE! error?

[crimsonkng]

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(A44>0,($J$202/$U$202)/12,0)
I get a #VALUE! error

A similar formula in Cell K308
=SUM(K158:K178)+IF(A15>0,($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

 

[JE McGimpsey]

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

 

[Arvi Laanemets]

Hi

What you do have in cell K182 ?
When nothing, then with + operator Excel assumes that it is an empty string,
i.e. you formula is same as
= "" + SomeNumber
You can't add strings and numbers, i.e. the formula returns an error.

Try instead
=SUM(K182,IF(A44>0,($J$202/$U$202)/12,0))
Unlike + operator, the SUM function ignores empty cells.


Arvi Laanemets

 

[crimsonkng]

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

 

[crimsonkng]

Yer a pal.
Dan

Hi

What you do have in cell K182 ?
When nothing, then with + operator Excel assumes that it is an empty string,
i.e. you formula is same as
= "" + SomeNumber
You can't add strings and numbers, i.e. the formula returns an error.

Try instead
=SUM(K182,IF(A44>0,($J$202/$U$202)/12,0))
Unlike + operator, the SUM function ignores empty cells.


Arvi Laanemets