ADD NEGATIVE NOT POSATIVE

[mark d davis]

EXAMPLE..
A1295.00) A35:295
A1:295 A35:295
A50=A1295)+A35:
IF A1: IS A POSATIVE NUMBER DO NOT ADD TO A35: BUT IF A1:IS A NEGATIVE
NUMBER ADD TO A35:

 

[Bernard Liengme]

Could you be less cryptic?

 

[Tushar Mehta]

By 'Net convention, using all capitals is the equivalent of shouting.
You may want to keep that in mind for future posts.

It is not clear what exactly you want, but may what you want is in A50
the formula =A35+MIN(A1,0)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[mark d davis]

sorry for the caps. not ment to be yelling. default on this computer.

 

[mark d davis]

N4 $(34.79)
N5 $0.69
N6
N7 $(34.10)
N8
N9 $10.00
N10 $-
N11 $-
N12 $-
N13
N14 $683.72
N15 $15.00
N16 $132.17
N17 $169.17
N18 $120.88
N19 $-
N20 $45.00
N21 $-
N22 $1,105.91
N23 $21.13
N24 $1,127.04
N25
N26 $1,127.04
N27 $1,165.94
N28 $38.90
N29 $313.66
N30 $812.17
N31 $313.66
N32 $120.88
N33
N34 $4.83
If N7 is a negative number, it adds to N28 to get the sum of N34. If N7 is a
posative number then N28 is the sum.
Does this help.
Mark

 

[Tushar Mehta]

My previous answer still holds. Of course, since you changed the cell
references in this post, you will have to correspondingly adjust the
references in the answer.

=N28+MIN(N7,0)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[mark d davis]

Thank's, I had already answered this before you got back. I appreciate the
help.