Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deduct until last positive number remaining
Thanks in advance! I hope I can explain my question adequately: I have a list of amouonts 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=536357 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deduct until last positive number remaining
With 1000000 in cell B1. amd the amounts 5000, 15000 in A2:A???, a formula like this in cell B2,
copied down.... =IF(B1="","", IF(B1-A2<0,"",B1-A2)) HTH, Bernie MS Excel MVP "krismtx" wrote in message ... Thanks in advance! I hope I can explain my question adequately: I have a list of amouonts 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=536357 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
get lowest positive number | Excel Discussion (Misc queries) | |||
how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions |