Help with Formula for Baccarat

I am trying to write a formula for the game of baccarat. It has a notorious 3rd card rule to determine whether the "Banker" or the "Player" will take a third card.

The simplest way I can think to do this would basically be...

I have the Player Card in A1, The Banker Card in B1
I am trying to put if A1=0 & B1=0 Then ... "Display this text", if A1=0 & B1 = 1 Then... "Display this different text" and so on.

I can get parts of the formula, but every time I try to put it all together, I am getting errors.

Any chance you can help me? I feel like its easier than I'm making it.

I appreciate your help.

I can get parts of the formula, but every time I try to put it all together, I am getting errors.

Given you have that much (and we don't)

Please upload a sample workbook. The instructions are the top of the page in the 'gold' banner. HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Originally Posted by dareeldill

I am trying to put if A1=0 & B1=0 Then ... "Display this text", if A1=0 & B1 = 0 Then... "Display this different text"

Those two conditions are exactly the same. Maybe it would help if you would tell us exactly what the notorious rule is and also what are A1 and B1.

Please see: HOW TO ATTACH YOUR SAMPLE WORKBOOK at the top of this page.

Are the numbers in B3 and C3 the value of each hand (not just a card)?

I suggest you use a table with all of the possibilities and results and then use a formula to look up the current state in the table. That is much better than writing a big formula that takes into account every possibility.

I did a little homework on this. You need to evaluate two states:

1. The first state is after the initial deal. The first action is what the player does, either draws a third card, or stands, based on this first state (the player draws unless he has a natural win, or has 6 or 7, or the Bank has a natural win).
   
   
2. The second state is after the player's move (which was either draw or stand). This action considers the bank's hand and the player's third card. The bank's move depends on the bank's hand plus the player's third card, if the player drew.

Your model seems to use only one state. You cannot know what the Bank will do until after the player draws a card, because the player's third card has to be taken into account with the bank's hand to determine whether the bank will draw or stand.

This is an interesting problem but I have limited time today. I'll get back to you when I can.

Dang it. You’re right about having to have the bankers hand be determined by the players third card.

I was so tired when I started this. I’m gonna have to think about this again and see how I want to do this.

Frustrating. Thanks for taking the time to look like you did. I appreciate it.

The only thing I knew about Baccarat is that there were playing it in the original Casino Royale movie. Interesting game.

Have a look at this. This plays one hand all at once. To make it more interesting to watch you could implement this in VBA so that you can deal one card at a time for added suspense, but it would be a complete rebuild.