software

This is my second post. I hope to explain myself better, so I can find a
solution.

A B

10 Declining difference
4 6=A1-A2
8 -2=(B2-A3)

I want to know the remaining positive number which is 4, not -2
If I begin with 10 and keep subtracting numbers, I want to end up with
a non-negative number.
Subtracting 10-4=6
Subtracting 6-8=-2, bit what I want is the number 4, the quot;remainingquot;
amount.

Thanks!--
krismtx
------------------------------------------------------------------------
krismtx's Profile: www.excelforum.com/member.php...oamp;userid=33462
View this thread: www.excelforum.com/showthread...hreadid=542334
krismtx Wrote:
gt; This is my second post. I hope to explain myself better, so I can find a
gt; solution.
gt;
gt; A B
gt;
gt; 10 Declining difference
gt; 4 6=A1-A2
gt; 8 -2=(B2-A3)
gt;
gt; I want to know the remaining positive number which is 4, not -2
gt; If I begin with 10 and keep subtracting numbers, I want to end up with
gt; a non-negative number.
gt; Subtracting 10-4=6
gt; Subtracting 6-8=-2, bit what I want is the number 4, the quot;remainingquot;
gt; amount.
gt;
gt; Thanks!

huh!!
maybe you mean this
=$A$1-A2
=$A$1-B2--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=542334If I understand correctly, you would put in B3:

=if(b2lt;a3,a2,b2-a3)

This will give you 4 as your answer (from cell A2), although I don't understand
why 6 wouldn't be the quot;remainingquot; amount, not 4.

--
Regards,
Fredquot;krismtxquot; gt; wrote in
message ...
gt;
gt; This is my second post. I hope to explain myself better, so I can find a
gt; solution.
gt;
gt; A B
gt;
gt; 10 Declining difference
gt; 4 6 =A1-A2
gt; 8 -2 =(B2-A3)
gt;
gt; I want to know the remaining positive number which is 4, not -2
gt; If I begin with 10 and keep subtracting numbers, I want to end up with
gt; a non-negative number.
gt; Subtracting 10-4=6
gt; Subtracting 6-8=-2, bit what I want is the number 4, the quot;remainingquot;
gt; amount.
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; krismtx
gt; ------------------------------------------------------------------------
gt; krismtx's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33462
gt; View this thread: www.excelforum.com/showthread...hreadid=542334
gt;