Spreadsheet: 703725d1605136250-craps-game-spreadsheet-need-help-with-formulas-6-8-outcomes-3-
Sheet: 6,8 outcomes (3)

D1 | D2 | Total |  | Roll Count | COR? | # Rolled | SP, 7out, MP | W/L | Net | B? | B Level |  |  | COR | SP | B Level | Net |  | Thank you for your help. Moving forward with the CRAPS game spreadsheet (see attachment),
 |  |  |  | 1 | COR | 10 |  |  |  |  |  |  |  | 2 | 4 | 11 | 35 |  | I added columns for "Win/Loss", "Net Win", "Bet?", and "Bet Level" (columns F, G, H, and I respectively).
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 3 | 5 | 21 |  |  | Column M has the list for the "Bet Level".
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 7 | 6 | 22 | 31 |  | Column N has the list for "Net Win" awarded after the corresponding "Bet Level" Win.
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 11 | 8 | 31 |  |  | I was able to do the formulas for "Win/Loss" (Column F).
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 12 | 9 | 32 | 27
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 10 | 41 |  |  | Rules for "Win/Loss", "Net Win", "Bet?", and "Bet Level":
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 42 | 36 |  | 1) (done) [NAME] only wins if 6 or 8 is rolled during a non-COR (non-come out roll). The "MP" is irrelevant.
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 51 |  |  | 2) (done) [NAME] only loses when it's a "7out".
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 52 | 50 |  | 3) First "bet" is made when the first SP (shooter point) is established.
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 61 |  |  | 4) A "bet" is always made after a win (W)
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 62 | 49 |  | 5) A "bet" is always made after the first "SP" is established following a loss (L)
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 71 |  |  | 6) A "bet level" value is given for each "bet"
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 72 | 38 |  | 7) The "bet level" value (Column M) keeps increasing (going down the list) until a non-zero "net win" value is awarded
 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 81 |  |  | 8) A "net win" is awarded after each "W"
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 82 | 44 |  | 9) The "net win" value depends on the "bet level" from the previous "bet level"
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 91 |  |  | 10) Once a non-zero "net win" value is awarded, the "bet level" for that roll reverts back to the beginning of the list (Column M)
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 92 | 40
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 101 |  |  | So, as you can see it gets a bit complicated for me, so any help is appreciated. Thank you so much!
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 102 | 35
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 111
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 112 | 41
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 121
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 122 | 40
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 131
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 132 | 42
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 141
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 142 | 43
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | Over
 |  |  |  |  |  | 5
 |  |  |  |  |  | 8
 |  |  |  |  |  | 7
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7