Calculating probability

Hi!

I have been trying for a couple of weeks to achieve this so would be very grateful for any help.

I am trying to create a spreadsheet that calculates the probability of reaching a certain number with various different numbers. It is to try and calculate the probability of winning at the game blackjack. For example, I have the numbers 2-10 and a number that can either be 1 or 11. There are a different number of each of these that I would know, such as 10 5's, 15 8's, 11 9's, etc. using a combination of these cards I want to know what the probability is of beating the dealers hand. The dealer has to take another card if he is on 16 or less. If I go a over 21, I lose. I am given two card that equal for instance 12 (9 and a 4) and the dealer is dealt one card, a 10. I want to know what the chances are of winning. I have tried with IF statements and it is far too complicated because there are so many combinations to get 21 (I.e. 12+1+1+1+1+5, 12+2+1+6, 12+1+1+7, etc) I have been told that Visual Basic might work but haven't had any luck with it. I would also like to know if I should take a card or stick.

I hope I've explained myself well enough for you to understand!?

Thanks!

Ben

Concentrate on determining the total number of cards in the deck - (the cards that have already been dealt / total instances of those cards in full deck)

THe tricky bit I think you will find is making it determine when to use 11 or 1 for an A.