/blogentry/22400 winsumloosesum's Blog: Digit Combos to VTRAC - Excel Formulas en-us Lottery Post RSS Generator /blogentry/22400 /blogentry/22400 Sun, 11 May 2008 01:15:55 GMT winsumloosesum Pick 4 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 4 Digit Combo

Example: 0012

Make sure you format the cell (Right Click cell A1 Select Format Cells Click Custom in Category List Enter 4 zeroes in the Type Box Click OK

In cell B1 copy and paste this formula:

=SUMPRODUCT((MOD(MID(TEXT(A1, 0000 ),ROW($1:$4),1),5)+1)*(10^(4-ROW($1:$4))))

The Pick 4 VTRAC Combo will now be in cell B1.

========================================================================

Pick 3 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 3 Digit Combo

Example: 001

Makesure you format the cell (Right Click cell A1 Select Format Cells Click Custom in Category List Enter 3 zeroes in the Type Box Click OK

In cell B1 copy and paste this formula:

=VALUE(CONCATENATE(MOD(VALUE(LEFT(TEXT(A1, 000 ),1)),5)+1,MOD( VALUE(MID(TEXT(A1, 000 ),2,1)),5)+1,MOD(VALUE(RIGHT(A1,1)),5)+1))

The Pick 3 VTRAC Combo will now be in cell B1.

Special thanks to members at MrExcel Forum for all their help!!!

... [ More ]

]]> Blog Entry winsumloosesum https://www.lotterypost.com/blogentry/22400