Doing the Math
Strategy: It depends on how many numbers are in the game. You need to figure out the number of possible combinations there are in the game. You can use the COMBIN function to figure out the number of combinations by selecting six numbers out of a group of 40.
1) Set up a spreadsheet with the number of balls in your lotto game in cell C2.
2) Identify how many numbers you need to select correctly in cell D2.
3) Enter the formula =COMBIN(C2,D2) in cell E2, as shown in Fig. 451. (Click image for a larger view.)
If your state lottery game requires you to select six numbers out of 40, then the odds against you winning are 3.83 million to one. For a $1 bet and an $8 million payout, the odds are in your favor.
For a game with 44 numbers, the odds are 7 million to one. This payoff is only slightly in your favor.
For games with 48 or 54 numbers, the payout is not worth the long odds of the game.
Additional Information: COMBIN figures combinations. Here, the sequence in which the balls are drawn in is not relevant. If you had a game where you had to match both the numbers and the order in which they were drawn, then you would want to use the PERMUT function to find the number of permutations of drawing six numbers in sequence out of 40.
Summary: Use the COMBIN or PERMUT functions for figuring the number of combinations or permutations.
Functions Discussed: =COMBIN(); =PERMUT()