Welcome Guest
( Log In | Register )
The time is now 8:37 pm
You last visited January 22, 2017, 7:16 pm
All times shown are
Eastern Time (GMT-5:00)

Digit Combos to VTRAC - Excel Formulas

Published:

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!!!

Entry #115

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.