software

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 quot;positive remainderquot;. I do not want a
negative number.

*$100,000.00*Amounts to be deductedDeclining 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: www.excelforum.com/member.php...oamp;userid=33462
View this thread: www.excelforum.com/showthread...hreadid=536357With 1000000 in cell B1. amd the amounts 5000, 15000 in A2:A???, a formula like this in cell B2,
copied down....

=IF(B1=quot;quot;,quot;quot;, IF(B1-A2lt;0,quot;quot;,B1-A2))

HTH,
Bernie
MS Excel MVPquot;krismtxquot; gt; wrote in message
...
gt;
gt; Thanks in advance!
gt; I hope I can explain my question adequately:
gt; I have a list of amouonts that are being deducted from 100,000. I would
gt; like to deduct until I get the quot;positive remainderquot;. I do not want a
gt; negative number.
gt;
gt; *$100,000.00* Amounts to be deducted Declining total
gt;
gt; first $5,000.00 $95,000.00 $5,000.00
gt; next $15,000.00 $80,000.00 $15,000.00
gt; next $25,000.00 $55,000.00 $25,000.00
gt; next $35,000.00 $20,000.00 $35,000.00
gt; next $45,000.00 -$25,000.00 *$20,000.00*
gt; *$100,000.00*
gt;
gt;
gt; --
gt; krismtx
gt; ------------------------------------------------------------------------
gt; krismtx's Profile: www.excelforum.com/member.php...oamp;userid=33462
gt; View this thread: www.excelforum.com/showthread...hreadid=536357
gt;