OK. No problems. It is a target staking plan whereby 1-6 is my target of 40. Obviously loosing bets are added to the target. This is working fine and when in this mode bets are increased until winners bring back the target to 40.
There is another column (l)which is the bank and fluctuates up and down.
I would like to, if possible have the target made into a % of the Bank only when it peaks. In other words is my bank were $500 and reaches say $550 I would like the target to remain at that level and not reduce.

=IF(I6-K6<40,(40),(I6-K6)) Bet 6

=IF(I47-K47<40,(40),(I47-K47)) Bet 47

If not possible, any suggestions as to how to do it manually.

Thanks
Enjay