Hello, I am a student who decided to take on a small project for fun. I ran into a problem so I decided to post on these forums. My project is a blackjack odds calculator. There are 9 hands you can bust off if you hit, 12, 13, 14, 15, 16, 17, 18, 19 and 20. Also, there are 26 different ways you can have cards that omit cards that make you bust from the deck. For instance, if you have a 2 and 10 and the dealer has a 10 there are 2 cards gone that make you bust. I spent a couple hours making a formula that has over 200 IF statements and over 10,000 characters. Does anyone know a way to separate my formula into 9 parts for each hand? And if this is possible, is there anyway to ensure that the formula updates the cell number as it progress down the page? Thank you.
Bookmarks