Welcome Guest
Log In | Register )
The time is now 6:25 pm
You last visited October 22, 2014, 6:21 pm
All times shown are
Eastern Time (GMT-5:00)

pick 3 mirros formula help

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

Page 1 of 1
PrintE-mailLink
Avatar

Philippines
Member #67927
December 8, 2008
67 Posts
Offline
Posted: July 25, 2011, 10:12 am - IP Logged

hello just wanted to ask if there is a formula for pick 3 mirrors for excel? like for example IN COLUMNS ABC are the winning numbers ang the mirrors are in cloumns EFG. is there a formula that i can use for it? tnx alot in advance. :)

     A     B     C    D     E     F     G

1   1     2     3           6     7     8

2

3

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    17937 Posts
    Offline
    Posted: July 25, 2011, 11:07 am - IP Logged

    hello just wanted to ask if there is a formula for pick 3 mirrors for excel? like for example IN COLUMNS ABC are the winning numbers ang the mirrors are in cloumns EFG. is there a formula that i can use for it? tnx alot in advance. :)

         A     B     C    D     E     F     G

    1   1     2     3           6     7     8

    2

    3

    Cell E1: =MOD(A1+5,10)

    Cell F1: =MOD(B1+5,10)

    Cell G1: =MOD(C1+5,10)

    A mind once stretched by a new idea never returns to its original dimensions!

      Avatar

      Philippines
      Member #67927
      December 8, 2008
      67 Posts
      Offline
      Posted: July 25, 2011, 11:21 am - IP Logged

      tnx alot sir. :) you've been helping me alot. :) also i have another question is it possible to make a formula like this if my vtracs are like these

      0 = 1

      2 = 3

      4 = 5

      6 = 7

      8 = 9

      tnx again sir. :)