Remove Profit From Cumulative Bank At Target

[honkin]

Is it possible to set a target where an amount of the cumulative bank would be taken?

As an example, let's assume column AO is the cumulative bank and every time it hits 10,000, 5,000 is removed. So the bank never gets higher than 10,000. How could that be achieved? Those amounts are just arbitrary, just to try and explain the concept.

I mean, it will never hit exactly 10,000, more like 10,347 or any sort of variation, but that will be the minimum. Once it hits a minimum of 10,000, that amount of 5,000 is deducted.

Ideally, it would be best to have the amount removed go in the next column, AP, so I figure that is where the formula will go. So the net result would be cumulative bank hits 10,000 in AO233 and now 5,000 is deducted and is in AP233. Does that make sense?

Now the sequence just continues until cumulative bank again hits a minimum of 10,000 and 5,000 is again deducted from AO into AP.

The staking is done in AI and is simply a % of the cumulative bank (2%), so no issues there (=AI2*0.02). It will easily adjust to the new cumulative bank

Any thoughts on how to have a formula in AP to handle profit taking?

 

[arthurbr]

Suppose the amounts to be added are in column A ( starting in A2) and your cumulative total in col B
In B2 enter

=sum($B1,$A2)-5000*(sum($b1,$a2)>10000)

and pull down

 

[honkin]

Suppose the amounts to be added are in column A ( starting in A2) and your cumulative total in col B
In B2 enter

=sum($B1,$A2)-5000*(sum($b1,$a2)>10000)

and pull down

cheers arthurbr
Thanks so much for this. It appears to be taking 5000 each time the bank hits 10000 or greater, which is fantastic.
A quick question. Based on this, obviously the cumulative bank will not be an accurate reflection of the actual results and I wonder how it is possible to monitor each of the 5000 amounts taken. Is there any way that the 5000 amounts taken now appear in the next column? Could it be done in the original formula or a separate formula in that next column?
Thanks again

 

[arthurbr]

Based on this, obviously the cumulative bank will not be an accurate reflection of the actual results and I wonder how it is possible to monitor each of the 5000 amounts taken. Is there any way that the 5000 amounts taken now appear in the next column? Could it be done in the original formula or a separate formula in that next column?

Try

=5000*(sum($b1,$a2)>10000)

in C2 and pull down

 

[honkin]

Try

=5000*(sum($b1,$a2)>10000)

in C2 and pull down

Apologies for the delay arthurbr
Yep, that's the bomb. Works a treat, so thanks very much

cheers

 

[arthurbr]

Most welcome