### Excel Blackjack Game

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

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

#### How to return and sum columns based on criteria/s

[QUOTE=NBVC;37076]Assuming the aquisition date is 1st of the month, try:

[COLOR=#0000ff]=SUMIFS(STRAIGHTLINE!\$D\$6:\$D\$8,STRAIGHTLINE!\$I\$6:\$I\$8,">0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")-SUMIFS(STRAIGHTLINE!\$I\$7:\$I\$401,STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")+SUMPRODUCT((STRAIGHTLINE!\$K\$7:\$K\$401:INDEX(STRAIGHTLINE!\$K\$7:\$V\$401,,MATCH(SUMMARY!\$E\$2,STRAIGHTLINE!\$K\$4:\$V\$4,0)))*(STRAIGHTLINE!\$B\$7:\$B\$401"Totals"))+STRAIGHTLINE!Z6...

nmmnyr Today, 12:37 AM

#### Categorizing based on multiple conditions & criteria containing text

Yes, I realized it was just a combination of the two different type of statements above as you also stated here. Thanks again, this was a huge help!...

AnnaB Yesterday, 10:25 PM

#### Need help with the diagram

I need this data in a diagram

something like this

Its very important that the percent value is the visual diagram and the 3rd...

J0hNTH3P4P7T0 Yesterday, 08:14 PM

#### Categorizing based on multiple conditions & criteria containing text

Do you mean?

=IF(A2="","",IF(OR(ISNUMBER(SEARCH({"X","Y"},A2))),"Category1",IF(OR(ISNUMBER(SEARCH({"A","B","C"},A2))),"Category2",IF(OR(ISNUMBER(SEARCH({"M","N"},A2))),"Category3","Other"))))...

NBVC Yesterday, 06:38 PM

#### Categorizing based on multiple conditions & criteria containing text

Actually, I do have one more follow up questions. How would you recommend I go about blanks vs. "other". I see you have an else ""...

AnnaB Yesterday, 05:33 PM