Hi Keith,
if the question is related to excel itself, try using the "Choose" formula.
If cell A1 contains the variable "losses" then
=CHOOSE(A1,2,2,2,4,4,4,8,8,8,16,16,16)
will yield 2 for 1,2,3; 4 for 4,5,6; 8 for 7,8,9; etc.
You can put error protection around this by using Choose within an IF statement or IFERROR
e.g. Your "Stake" cell could say =If(losses <=12, CHOOSE(A1,2,2,2,4,4,4,8,8,8,16,16,16), 2)
regards
Wez