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

why am I getting a #VALUE! error?
 

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

why am I getting a #VALUE! error?
 

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(A440,($J$202/$U$202)/12,0))
Unlike + operator, the SUM function ignores empty cells.


Arvi Laanemets


"crimsonkng" wrote in message
...
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

why am I getting a #VALUE! error?
 

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

why am I getting a #VALUE! error?
 

Yer a pal.
Dan

"Arvi Laanemets" wrote:

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(A440,($J$202/$U$202)/12,0))
Unlike + operator, the SUM function ignores empty cells.


Arvi Laanemets


"crimsonkng" wrote in message
...
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