Mac,

2) 21 numbers chosen, 59 not chosen, so each could be paired with any, for a
total of

=21*59

or the 1239 that you calc'd.

3) 59 numbers not chosen, means:

=COMBIN(59,2)

will give the 1711

HTH,
Bernie
MS Excel MVP

"mac_see" wrote in message
...
In a lotto game, 21 balls gets picked up from a pot of 80 balls.

Scenario 1

If I create all possible combinations of 80 numbers, I get 3160
combinations
[=COMBIN(80,2)].
If I create all possible combinations of 21 numbers (the ones that gets
picked up), I get 210 combinations [=COMBIN(21,2)].

That means if I look at combinations, 210 combinations clicks in one draw
out of 3160.

Scenario 2

There are in all 3160 combinations of 2 numbers. If I check both the
numbers
individually, there are chances that both the numbers in a combination of
2
will be present in the draw of 21 numbers or there could be only 1 out of
the
2 numbers in a combination that will be present in the draw of 21. The
above
scenario says that there are 210 combinations that matches 2 on 2 and an
analysis that I did manually, it says there are 1239 combinations that
matches 1 on 2. Can we come to this figure (1239) using any formula?

Scenario 3

Similary, if I check both the numbers individually, there could be chances
that both the numbers did not fall in the draw of 21 numbers. These are
1711
combinations. Again, Can we come to this figure (1711) using any formula?


I need a formula for calcuating 1 on 2 (scenario2) and 0 on 2 (scenario3)

2:2 =COMBIN(21,2) = 210
1:2 NEED FORMULA = 1239
0:2 NEED FORMULA = 1711
------------------------------------------
The total for above is 3160