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" <krismtx.26vg8m_1146055201.8242@excelforum-nospam.com> wrote in message
news:krismtx.26vg8m_1146055201.8242@excelforum-nospam.com...
>
> 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
>