### Excel Blackjack Game

by Published on 2010-11-15 08:57 PM     Number of Views: 31662

Just for fun, I decided that I would build a game in Excel, so here's my version of Blackjack.

Features:
The rules are pretty standard Blackjack rules... adjust your bet, then hit Deal. You get two cards, the dealer gets one up, one face down. You can hit or stay, and the hand will unfold for you.
...
• ### Recent Forum Posts

#### Tracking numbers in a row & counting them in columns

Try this one in I5 copied across and down:

=SUMPRODUCT(COUNTIF(\$H5:\$K5,S\$5:S\$13))

=MAX(range) simply finds the...

AliGW Today, 05:32 PM

#### Tracking numbers in a row & counting them in columns

Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

How would the formula be different if my numbers...

ExcelHelpNeeded Today, 04:51 PM

#### Tracking numbers in a row & counting them in columns

That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

ExcelHelpNeeded Today, 03:34 PM

#### differences between Excel.workbook... and ~.CurrentWorkbook function

I have now adapted the workaround "Calculation of duration" so that it can be used directly for the import from a workbook as well as for the...

pinarello Today, 02:51 PM

#### Tracking numbers in a row & counting them in columns

One way!

In I5 copied across and down:

=COUNTIFS(\$C5:\$F5,">="&MIN(N\$5:N\$13),\$C5:\$F5,"...

AliGW Today, 08:36 AM