Negative numbers

[krismtx]

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 "remaining"
amount.

Thanks!

 

[davesexcel]

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 "remaining"
amount.

Thanks!

huh!!
maybe you mean this
=$A$1-A2
=$A$1-B2

 

[Fred Smith]

If I understand correctly, you would put in B3:

=if(b2<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 "remaining" amount, not 4.