Subtract in excel
 

Thanks in advance!
I hope I can explain my question adequately:
I have a list of amounts that are being deducted from 100,000. I would
like to deduct until I get the "positive remainder". I do not want a
negative number.

$100,000.00 Amounts to be deducted Declining total

first $5,000.00 $95,000.00 $5,000.00
next $15,000.00 $80,000.00 $15,000.00
next $25,000.00 $55,000.00 $25,000.00
next $35,000.00 $20,000.00 $35,000.00
next $45,000.00 -$25,000.00 $20,000.00
$100,000.00


--
krismtx
------------------------------------------------------------------------
krismtx's Profile: http://www.excelforum.com/member.php...o&userid=33462
View this thread: http://www.excelforum.com/showthread...hreadid=536368

Subtract in excel
 

Sorry to re-post.:confused: I didn't think my original posted


--
krismtx
------------------------------------------------------------------------
krismtx's Profile: http://www.excelforum.com/member.php...o&userid=33462
View this thread: http://www.excelforum.com/showthread...hreadid=536368

Subtract in excel
 

Hi

Assuming your data is set out as follows
B1 100000
A2 5000, A3 15000, A4 25000, A5 35000, A6 45000

In cell B2 enter
=MAX(0,B1-A2)
in C2 enter
=B1-B2
Copy B2:C2 down through B2:B6


--
Regards

Roger Govier


"krismtx" wrote
in message ...

Thanks in advance!
I hope I can explain my question adequately:
I have a list of amounts that are being deducted from 100,000. I would
like to deduct until I get the "positive remainder". I do not want a
negative number.

$100,000.00 Amounts to be deducted Declining total

first $5,000.00 $95,000.00 $5,000.00
next $15,000.00 $80,000.00 $15,000.00
next $25,000.00 $55,000.00 $25,000.00
next $35,000.00 $20,000.00 $35,000.00
next $45,000.00 -$25,000.00 $20,000.00
$100,000.00


--
krismtx
------------------------------------------------------------------------
krismtx's Profile:
http://www.excelforum.com/member.php...o&userid=33462
View this thread:
http://www.excelforum.com/showthread...hreadid=536368