Welcome Guest
Log In | Register )
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
PrintE-mailLink
Sage's avatar - Lottery-035.jpg
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.Big Smile

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

    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    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.Big Smile

    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

    Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

    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...Thumbs Up

      Sage's avatar - Lottery-035.jpg
      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?   See Ya!

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

        LottoChica23's avatar - Aquarius
        Fughedaboutit (NY)
        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?   See Ya!

        You're quite welcome. Wink

        I'm doing well. See Ya!

        Enjoy the holidays!Turkey

        Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

        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...Thumbs Up

          Sage's avatar - Lottery-035.jpg
          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. Wink

          I'm doing well. See Ya!

          Enjoy the holidays!Turkey

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

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