Welcome Guest
You last visited August 23, 2017, 12:02 am
All times shown are
Eastern Time (GMT-5:00)

# pick 3 mirros formula help

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

 Page 1 of 1

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

New Jersey
United States
Member #17843
June 28, 2005
64981 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!

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. :)

 Page 1 of 1