Welcome Guest
You last visited December 9, 2016, 8:24 am
All times shown are
Eastern Time (GMT-5:00)

# Need Excel Help with Vtracs

Topic closed. 4 replies. Last post 6 years ago by Sage.

 Page 1 of 1
Dunwoody Georgia
United States
Member #747
September 29, 2002
659 Posts
Offline
 Posted: November 21, 2010, 11:10 am - IP Logged

I need a formula  to convert a regular digit to a vtrac.

Can anyone help me?  Thanks.

It's Never Too Late To Be The Person You Could Of Been!

United States
Member #8160
October 26, 2004
6777 Posts
Offline
 Posted: November 21, 2010, 11:26 am - IP Logged

I need a formula  to convert a regular digit to a vtrac.

Can anyone help me?  Thanks.

Try this:

For 3 Digit numbers

=MOD(INT(P3/100),5)*100+MOD(INT(P3/10),5)*10+MOD(P3,5)+111

Change the P3 in the formula to the cell that your 3 digit number is in

For Single Digits

=MOD(P3,5)+1

Chang the P3 to the respective cells that your single digits are in

check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

You can judge the integrity of a man by the way he treats those that can do nothing for him...

Dunwoody Georgia
United States
Member #747
September 29, 2002
659 Posts
Offline
 Posted: November 21, 2010, 11:34 am - IP Logged

Try this:

For 3 Digit numbers

=MOD(INT(P3/100),5)*100+MOD(INT(P3/10),5)*10+MOD(P3,5)+111

Change the P3 in the formula to the cell that your 3 digit number is in

For Single Digits

=MOD(P3,5)+1

Chang the P3 to the respective cells that your single digits are in

Wow that was so fast  Thank you so much!  you guys and Gals are the best!  How have you been Lottochica23?

It's Never Too Late To Be The Person You Could Of Been!

United States
Member #8160
October 26, 2004
6777 Posts
Offline
 Posted: November 21, 2010, 11:48 am - IP Logged

Wow that was so fast  Thank you so much!  you guys and Gals are the best!  How have you been Lottochica23?

You're quite welcome.

I'm doing well.

Enjoy the holidays!

check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

You can judge the integrity of a man by the way he treats those that can do nothing for him...

Dunwoody Georgia
United States
Member #747
September 29, 2002
659 Posts
Offline
 Posted: November 21, 2010, 4:27 pm - IP Logged

You're quite welcome.

I'm doing well.

Enjoy the holidays!

Thank you so much!  It worked like a charm!  Your the best LottoChica23.  Many blessing to you and yours!  Have a wonderful weekend!

It's Never Too Late To Be The Person You Could Of Been!

 Page 1 of 1