Hi I'm new to the forum so please forgive the title, it may not be accurate!

Let me explain a little, this is probably more a maths problem but I want to do it in excel and I am struggling with getting the maths right, I'm hoping some one can help?

For years I have had a fascination with the lottery, purely hobby, and have had lots of fun over the years working different things out. The last 6 months though I have become fascinated with roulette & thought it would be a fun project to work out all sorts based around that, plus I don't have to wait for lotto results I can get instant numbers & results, however my latest attempts are hitting a brick wall!

I am trying to work out (in percentages) the increasing & decreasing % of 3, 11, 12, 22, possible outcomes

I have worked out the 2 possible outcomes initially for odd/even as follows

At the start they both have a 48.65% chance of hitting, then whatever is hit first the percentages are 76.33% and 23.67%. If you have 2 in a row of odd/even then the percentages are 88.49% & 11.51%, 3 in a row would give you 94.40% & 5.60% etc.

I have used the following formula for this (BM5 is where the totalhits for even are calc'd)

=IF(BM5=1,$C10*$C10,IF(BM5=2,$C10*($C10*$C10),IF(BM5=3,$C10*($C10*($C10*$C10)),IF(BM5=4,$C10*($C10*($C10*($C10*$C10))),IF(BM5=5,$C10*($C10*($C10*($C10*($C10*$C10)))),IF(BM5=6,$C10*($C10*($C10*($C10*($C10*($C10*$C10))))),IF(BM5=7,$C10*($C10*($C10*($C10*($C10*($C10*($C10*$C10)))))),IF(BM5=8,$C10*($C10*($C10*($C10*($C10*($C10*($C10*($C10*$C10))))))),IF(BM5=9,$C10*($C10*($C10*($C10*($C10*($C10*($C10*($C10*($C10*$C10)))))))))))))))))

and the same but in BM4 for tracking the even!

This works great, but I'm sure there must be a better way! BUT I have no clue how to advance this for 3 possible outcomes and more!

Can anyone help? I have been stuck on this for 2 months now and its really annoying!