Hi, I have a table as below

Col A (%) Col B (total) Col C (Amount) Col D (Carried Over) Col E
(Paid Out)
10% $1000 $100 $100
$0
100% $1000 $1000 $0
$1000+100
50% $1000 $500 $500
$0
25% $1000 $250 $250
$0
85% $1000 $850 $0
$850+500+250

Okay scenario is that if Col A is under 85%, then nothing gets paid out, but
the amount in Col C is carried over until next time.

If Col A is over 85%, then the Paid Out is Col C, plus whatever has
previously been carried over. The tricky part is, as can be seen in the last
row, that the Carried over can only be included in the calculation if it has
not already previously been allocated.

I need a formula that keeps a sum of Col D, but resets the back to zero if
an amount is Paid Out.

Thanks in advance for any help on this, Im not sure where to begin.

Sorry for back formatting, have fixed.

"Wahine" wrote:

Hi, I have a table as below

Col A(%) Col B(total) Col C(Amount) Col D(Carried Over) Col E(Paid Out)
10% $1000 $100 $100
$0
100% $1000 $1000 $0
$1000+100
50% $1000 $500 $500
$0
25% $1000 $250 $250
$0
85% $1000 $850 $0
$850+500+250

Okay scenario is that if Col A is under 85%, then nothing gets paid out, but
the amount in Col C is carried over until next time.

If Col A is over 85%, then the Paid Out is Col C, plus whatever has
previously been carried over. The tricky part is, as can be seen in the last
row, that the Carried over can only be included in the calculation if it has
not already previously been allocated.

I need a formula that keeps a sum of Col D, but resets the back to zero if
an amount is Paid Out.

Thanks in advance for any help on this, Im not sure where to begin.