IF - Bet Selection

Hello Everyone,

I am interest to have testing on some of my betting methods.
For example, there have 2 bet decisions of “B” or “P”

Rules for Method 1:
1)Initial bet start with 1 unit
2)+ 1 unit when win or – 1 unit when Lose.
3) Lose and "bet value" hit "-1", use "last open result " for next bet decision

Rules for Method 2:
1)Initial bet start with 1 unit
2)+ 1 unit when win or – 1 unit when Lose.
3) Count on the game run limit.
4)Remain same bet decision as long as does not hit game run limit, or switch to use "last open result" for next bet direction when hit game run limit

Predict/next bet is depend on the positive value of B /P after Method 1 minus Method 2.
The calculation is show in column J. It’s difficulty and careless when have manual calculation for short period

When entered “B” / “P” (column C), I am wondering if there is a formula to have “Predict/next bet (column H) “ & “Predict/next bet value ( column I )” to be appear for next bet decision


P/S: Please unhide all the column to have more detail explanations.

Is there anybody can help ?

I looking a formula for column H an I

Thanks you