A1 = total number of balls in the lottery, eg 49
A2 = number of balls drawn in the game, eg 6
A3 = number of balls matched by player, eg 6
A4 = odds of this occurrence to one, eg 13,983,816

Where you have 49 numbers, the chance of drawing the first number are 1 in
49. To draw the second number, because only 48 balls remain, it's 1 in 48,
etc. So in a draw 6 game with 49 balls, the odds of drawing out 6 in any
order are (49*48*47*46*45*44)/(6*5*4*3*2*1) or 49!/(6!*(49-6)!) which is
10,068,347,520/720 and gives 13,983,816.

I would like a formula to calculate odds for variations in value of A1, A2
and A3.

=HYPGEOMDIST function would seem to do what I'm looking for, but in the help
function they have population size, which would be A1, Sample size is A2,
Sucesses in sample is A3, but not successes in population. Any ideas?