CODEWITHSUNDEEP
excelprobabilityworksheet-functionfactorialpoker
Damian
Damian

Reputation: 25

Formula to calculate chances (poker probability)

The chance to have any 5 cards in poker is C(52,5) = 52! / [5!(52-5)!], so it is any 5 cards from all 52 possible cards. I tried using =prob(52,5,1,52) function, but I have no idea how to write it to get the correct outcome of 2598960.

I was wondering whether I can use a simple function to calculate that instead of long FACT() function.Should I use this function? How? If not this one, how should I do this correctly to get the right number?

Upvotes: 0

Views: 2242

Answers (1)

pnuts
pnuts

Reputation: 59485

I was wondering whether I can use a simple function to calculate that instead of long FACT() function.

Yes, please try COMBIN, for example: 

=COMBIN(52,5)

Upvotes: 1

Related Questions