Casino Blackjack Ace problem!!

DVLARMY

New Member
Joined
Apr 1, 2017
Messages
6
I building a player evaluation excel file for the casino game blackjack. The problem comes when a Ace is dealt.

In the game of blackjack the Ace has the value of 1 or 11.

For example when a 10 value card is dealt with an Ace the value of the Ace is 11 for a total of 21 (winner). If a 8 is dealt with an Ace the total would be soft 19 (8+11). On the other hand if a hand is dealt like..4, 6, 2, Ace the total would be 23 or 13. A 23 would be a automatic loser for the game so the player or dealer would treat the hand as a 13 and play on.

Right now I have the program using a 1 to represent an Ace for other parts of evaluation.

What I'm trying to do is have the program recognize that a 1=Ace can be a 1 value or 11 value as long when seen as an 11 the combined total is not over 21 but when the combined total is over 21 the value is 1.

Thank You for any thoughts on my problem.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,912
Messages
6,175,348
Members
452,638
Latest member
Oluwabukunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top