krismtx Wrote:
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
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=542334