Countif - Bet Selection 2

[bakaking]

Hi Everyone,
There have 3 different of betting methods. Bet method explained inside spreadsheet.

When entered “B” / “P” (column C), I am wondering if there is a excell formula ( for column B, C , D), in order to help generate input as per given
Could help ?

Thank.

[bakaking]

Is there anyone could help ?

[alphafoxtrot]

I think this is what you are looking for. It changes to "W" or "L" if the "open result" matches the "bet on" field and based on that result it updates the bank roll by +1 or -1.

Bet2.xlsx