Pick 4 Excel Formula

Reply #2

winsumloosesum — Fri, 13 Jul 2007 18:20:38 GMT

Adding Position formulas for Pick 4:

Thanks to Hypersoniq for these formulas!!!

Assuming Column Cell A1 is where you enter the 4 digit combos ...

Position 1 in cell B1 ... =INT(A1/1000)

Position 2 in cell C1 ... =INT((A1-(B1*1000))/100)

Position 3 in cell D1 ... =INT((A1-((B1*1000)+(C1*100)))/10)

Position 4 in cell E1 ... =INT((A1-((B1*1000)+(C1*100)+(D1*10))))

After you enter all these formulas just drag down until you have all 10000 combinations.

Reply #1

winsumloosesum — Fri, 13 Jul 2007 18:14:10 GMT

Paul,

Not sure what you want.

If you just want a list of 10,000 Pick 4 combinations just enter 0000 in cell A1

Click cell A1

Right Click>Format Cells>Select Number Tab (top)>Secect Custom (List)>Select 0 in the Type: (right side)

Enter 3 more zero's for a total of 4

Click OK

Cell A1 should have four zero's

Select cell A1 and place coursor at right hand lower corner.

Hold down the left mouse button and Drag the cross hairs down to cell A2.

Click cell A2 and delete th... [ More ]

Pick 4 Excel Formula

paulfig911 — Fri, 13 Jul 2007 16:30:19 GMT

Could someone tell me the formula I can use in Excel to calculate all 10,000 possible combinations for Pick 4 lottery?

Thank you.