View Full Version : Possible Hand Combinations

04-21-2005, 05:08 AM
I have been trying to recreate the Sklansky-Karlson (http://archiveserver.twoplustwo.com/showflat.php?Cat=&Number=382772&page=&view=&sb=5&o =&fpart=all&vc=1) hand rankings using microsoft excel. However I have run into a problem figuring out the number of possible hand combinations when I hold a specific hand. Because of the fact that excel can only have 7 nested IF statements. HERE ( is a link to the spreadsheet I am using. Every number in column B in the HandCombos worksheed should add up to 1225, however they do not and I cannot go any deeper into the if statements. Can anyone help me by telling me a formula I can enter that will give me the correct numbers, or an easier/better way of doing it?