Welcome Guest
Log In | Register )
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
PrintE-mailLink
bootleg233's avatar - Lottery-034.jpg
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 Big Smile

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

    Raven62's avatar - binary
    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!

      Avatar

      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 $

        bootleg233's avatar - Lottery-034.jpg
        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
        NO carry overs       Answers
         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 Big Smile

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

          bootleg233's avatar - Lottery-034.jpg
          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
          NO carry overs       Answers
           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 Big Smile

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