Welcome Guest
You last visited January 21, 2017, 12:28 pm
All times shown are
Eastern Time (GMT-5:00)

Lotto Math

Topic closed. 4 replies. Last post 5 years ago by bootleg233.

 Page 1 of 1
Tn
United States
Member #54963
September 4, 2007
1166 Posts
Offline
 Posted: August 3, 2011, 8:06 am - IP Logged

Ok heres the thing i just cant understand say i have  0 in A1 and 6 in B1 and 3 in C1 so i have 063  now i know how to get excel or openoffice to -1 from 0 to give me 9 but my problem comes if say i put 3 in A1 my lotto math screws up! Does this make sense what im trying to do? Let me try to explain better:

I have 063 or whatever numbers i put in

Now i want to say -1 or -2 whatever  to get say 9 or 8 in A1 lotto math. Ok i can do that but what if A1 is say 3 and i still want to -1 or say A1 is 1 and I want to -2 and have it be 9. I just need it to work if i put 0 in A1 or B1 or C1 or whatever or if i put any other number to give me answers to my math in say E1 F1 G1.I dont know how to word it lol!

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY

I think I can I think I can!!!!

New Jersey
United States
Member #17843
June 28, 2005
51178 Posts
Online
 Posted: August 3, 2011, 9:19 am - IP Logged

Ok heres the thing i just cant understand say i have  0 in A1 and 6 in B1 and 3 in C1 so i have 063  now i know how to get excel or openoffice to -1 from 0 to give me 9 but my problem comes if say i put 3 in A1 my lotto math screws up! Does this make sense what im trying to do? Let me try to explain better:

I have 063 or whatever numbers i put in

Now i want to say -1 or -2 whatever  to get say 9 or 8 in A1 lotto math. Ok i can do that but what if A1 is say 3 and i still want to -1 or say A1 is 1 and I want to -2 and have it be 9. I just need it to work if i put 0 in A1 or B1 or C1 or whatever or if i put any other number to give me answers to my math in say E1 F1 G1.I dont know how to word it lol!

Cell E1: =MOD(A1-1,10)

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

United States
Member #41846
June 23, 2006
460 Posts
Offline
 Posted: August 3, 2011, 12:17 pm - IP Logged

bootleg

it sounds like you want to use different values.  as -1 -2 etc.   Modify Raven62's method slightly to have a fixed reference cell  assume f1 will be your reference cell and it will contain a 1 or 2 or 3 etc.  this formuls now becomes =mod(a1-\$F\$1,10)      now the formula looks to cell f1 for a value to subtract  change f1 and all you values change.

change the "-" to a "+" and you can add whatever.  the F1 can be any cell just make it a fixed reference with the \$

Tn
United States
Member #54963
September 4, 2007
1166 Posts
Offline
 Posted: August 3, 2011, 12:38 pm - IP Logged

Ok heres what I need say I start with 063 ok now i want to be able to put this number or any other number such as 907  in cells A1 B1 C1
and then in cells E1 F1 G1  thru  E12 F12 G12  i need it to give me the answers to this math

X= stays the same
Math subtraction
x   x  -1          062
x   x  -2          061
x  -1  x           053
x  -1 -1          052
-1   x -1          962
-1   x -2          961
-1  -1  x-         953
-1  -1 -2          951
-2   x  -1          862
-2  -1 -1          852
-2  -2 -1          842
-2  -2  x           843

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY

I think I can I think I can!!!!

Tn
United States
Member #54963
September 4, 2007
1166 Posts
Offline
 Posted: August 3, 2011, 6:38 pm - IP Logged

Ok heres what I need say I start with 063 ok now i want to be able to put this number or any other number such as 907  in cells A1 B1 C1
and then in cells E1 F1 G1  thru  E12 F12 G12  i need it to give me the answers to this math

X= stays the same
Math subtraction
x   x  -1          062
x   x  -2          061
x  -1  x           053
x  -1 -1          052
-1   x -1          962
-1   x -2          961
-1  -1  x-         953
-1  -1 -2          951
-2   x  -1          862
-2  -1 -1          852
-2  -2 -1          842
-2  -2  x           843

Has been solved ty all who looked or replyed!

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY

I think I can I think I can!!!!

 Page 1 of 1