Welcome Guest
Log In | Register )
You last visited April 21, 2018, 5:14 am
All times shown are
Eastern Time (GMT-5:00)

excel formula to convert p3 number to vtrac?

Topic closed. 3 replies. Last post 8 years ago by jester001.

Page 1 of 1
PrintE-mailLink
Avatar
Thread Starter

Philippines
Member #67927
December 8, 2008
67 Posts
Offline
Posted: April 12, 2010, 10:00 am - IP Logged

hi is there an excel formula that i can use to convert the drawn p3 numbers to vtrac? thanks alot.

    Avatar
    Thread Starter

    Philippines
    Member #67927
    December 8, 2008
    67 Posts
    Offline
    Posted: April 12, 2010, 11:50 am - IP Logged

    nvm found the formula with the help of the search button. :)

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5793 Posts
      Offline
      Posted: April 12, 2010, 9:33 pm - IP Logged

      hi is there an excel formula that i can use to convert the drawn p3 numbers to vtrac? thanks alot.

      If your "position 1" digit is in cell A1

      =MOD(A1,5)+1

        Avatar
        Thread Starter

        Philippines
        Member #67927
        December 8, 2008
        67 Posts
        Offline
        Posted: April 13, 2010, 12:18 pm - IP Logged

        thanks alot sir will try it out.