Welcome Guest
Log In | Register )
You last visited December 8, 2016, 8:49 pm
All times shown are
Eastern Time (GMT-5:00)

excel formula to convert p3 number to vtrac?

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

Page 1 of 1
PrintE-mailLink
Avatar

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

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

        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.