software

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

A similar formula in Cell K308
=SUM(K158:K178) IF(A15gt;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

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

In article gt;,
crimsonkng gt; wrote:

gt; Hopefully, this is the correct forum in which to ask this question.
gt;
gt; In Cell K320, when the formula is
gt; =K182
gt; I get a blank (zero)
gt;
gt; But when the formula in in that same cell is
gt; =K182 IF(A44gt;0,($J$202/$U$202)/12,0)
gt; I get a #VALUE! error
gt;
gt; A similar formula in Cell K308
gt; =SUM(K158:K178) IF(A15gt;0,($J$202/$U$202)/12,0)
gt; works fine.
gt;
gt; I can't figure out why it's not working in K320.
gt;
gt; Thanks, in advance, for any help you can provide.
gt;
gt; 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
= quot;quot; SomeNumber
You can't add strings and numbers, i.e. the formula returns an error.

Try instead
=SUM(K182,IF(A44gt;0,($J$202/$U$202)/12,0))
Unlike operator, the SUM function ignores empty cells.Arvi Laanemetsquot;crimsonkngquot; gt; wrote in message
...
gt; Hopefully, this is the correct forum in which to ask this question.
gt;
gt; In Cell K320, when the formula is
gt; =K182
gt; I get a blank (zero)
gt;
gt; But when the formula in in that same cell is
gt; =K182 IF(A44gt;0,($J$202/$U$202)/12,0)
gt; I get a #VALUE! error
gt;
gt; A similar formula in Cell K308
gt; =SUM(K158:K178) IF(A15gt;0,($J$202/$U$202)/12,0)
gt; works fine.
gt;
gt; I can't figure out why it's not working in K320.
gt;
gt; Thanks, in advance, for any help you can provide.
gt;
gt; Dan
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

quot;JE McGimpseyquot; wrote:

gt; The operator returns #VALUE if either of its arguments are Text.
gt;
gt; In article gt;,
gt; crimsonkng gt; wrote:
gt;
gt; gt; Hopefully, this is the correct forum in which to ask this question.
gt; gt;
gt; gt; In Cell K320, when the formula is
gt; gt; =K182
gt; gt; I get a blank (zero)
gt; gt;
gt; gt; But when the formula in in that same cell is
gt; gt; =K182 IF(A44gt;0,($J$202/$U$202)/12,0)
gt; gt; I get a #VALUE! error
gt; gt;
gt; gt; A similar formula in Cell K308
gt; gt; =SUM(K158:K178) IF(A15gt;0,($J$202/$U$202)/12,0)
gt; gt; works fine.
gt; gt;
gt; gt; I can't figure out why it's not working in K320.
gt; gt;
gt; gt; Thanks, in advance, for any help you can provide.
gt; gt;
gt; gt; Dan
gt;

Yer a pal.
Dan

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; What you do have in cell K182 ?
gt; When nothing, then with operator Excel assumes that it is an empty string,
gt; i.e. you formula is same as
gt; = quot;quot; SomeNumber
gt; You can't add strings and numbers, i.e. the formula returns an error.
gt;
gt; Try instead
gt; =SUM(K182,IF(A44gt;0,($J$202/$U$202)/12,0))
gt; Unlike operator, the SUM function ignores empty cells.
gt;
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;crimsonkngquot; gt; wrote in message
gt; ...
gt; gt; Hopefully, this is the correct forum in which to ask this question.
gt; gt;
gt; gt; In Cell K320, when the formula is
gt; gt; =K182
gt; gt; I get a blank (zero)
gt; gt;
gt; gt; But when the formula in in that same cell is
gt; gt; =K182 IF(A44gt;0,($J$202/$U$202)/12,0)
gt; gt; I get a #VALUE! error
gt; gt;
gt; gt; A similar formula in Cell K308
gt; gt; =SUM(K158:K178) IF(A15gt;0,($J$202/$U$202)/12,0)
gt; gt; works fine.
gt; gt;
gt; gt; I can't figure out why it's not working in K320.
gt; gt;
gt; gt; Thanks, in advance, for any help you can provide.
gt; gt;
gt; gt; Dan
gt;
gt;
gt;