excel formula to convert p3 number to vtrac?Prev TopicNext Topic

• jester001

  

  Philippines
  Member #67,925
  December 8, 2008
  67 Posts
  Offline
  Apr 12, 2010, 10:00 am

  ▲▼

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

  

  Philippines
  Member #67,925
  December 8, 2008
  67 Posts
  Offline
  Apr 12, 2010, 11:50 am

  ▲▼

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

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Apr 12, 2010, 9:33 pm

  ▲▼
  In response to jester001

  Quote: Originally posted by jester001 on Apr 12, 2010

  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
• jester001

  

  Philippines
  Member #67,925
  December 8, 2008
  67 Posts
  Offline
  Apr 13, 2010, 12:18 pm

  ▲▼

  thanks alot sir will try it out.