Welcome Guest
Log In | Register )
You last visited January 23, 2017, 7:51 pm
All times shown are
Eastern Time (GMT-5:00)

excel addition

Topic closed. 4 replies. Last post 8 years ago by diamondpalace.

Page 1 of 1
PrintE-mailLink
diamondpalace's avatar - Untitled 2.jpg
Dallas, TX
United States
Member #60284
April 12, 2008
3856 Posts
Offline
Posted: November 17, 2008, 11:19 am - IP Logged

Would like some help on excel addition using lotto math, not traditional math. If I where to add 2 to 9, would like the answer to be 1 instead of 11. How can I program this in excel? Thanks.

    Bluegrass's avatar - nw archer.jpg
    Killer's Cove
    United States
    Member #57
    December 17, 2001
    5663 Posts
    Online
    Posted: November 17, 2008, 12:06 pm - IP Logged

    Would like some help on excel addition using lotto math, not traditional math. If I where to add 2 to 9, would like the answer to be 1 instead of 11. How can I program this in excel? Thanks.

     =MOD(2+9,10)

     

         US Flag    Life i$ good !  US Flagbg

             

      diamondpalace's avatar - Untitled 2.jpg
      Dallas, TX
      United States
      Member #60284
      April 12, 2008
      3856 Posts
      Offline
      Posted: November 17, 2008, 1:30 pm - IP Logged

       =MOD(2+9,10)

      Thanks Bluegrass. How can I program a cell to +222 to the selected cell for the SUM to lotto math?

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        51255 Posts
        Offline
        Posted: November 17, 2008, 2:48 pm - IP Logged

        Thanks Bluegrass. How can I program a cell to +222 to the selected cell for the SUM to lotto math?

        Rather than combining the three digits (ie: 345) it makes it easier to keep the three digits in separate cells (ie: a1=3 b1=4 c1=5): Otherwise you'll have to separate the combined digits to perform the (+/-) operation and then combine them again.

        Try this:
        a1=3 b1=4 c1=5 e1=2 f1=2 g1=2

        in a2 put
        =mod(a1+e1,10)

        in b2 put
        =mod(b1+f1,10)

        in c2 put
        =mod(c1+g1,10)

        Lottery Post Search is Your Friend:

        http://www.lotterypost.com/search?q=excel&t=all

        Many of the question you're going to ask about Excel have previously been answered.

        If you haven't done it yet: It would also pay to take a course in the version of Excel that you are using.

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

          diamondpalace's avatar - Untitled 2.jpg
          Dallas, TX
          United States
          Member #60284
          April 12, 2008
          3856 Posts
          Offline
          Posted: November 17, 2008, 3:36 pm - IP Logged

          Rather than combining the three digits (ie: 345) it makes it easier to keep the three digits in separate cells (ie: a1=3 b1=4 c1=5): Otherwise you'll have to separate the combined digits to perform the (+/-) operation and then combine them again.

          Try this:
          a1=3 b1=4 c1=5 e1=2 f1=2 g1=2

          in a2 put
          =mod(a1+e1,10)

          in b2 put
          =mod(b1+f1,10)

          in c2 put
          =mod(c1+g1,10)

          Lottery Post Search is Your Friend:

          http://www.lotterypost.com/search?q=excel&t=all

          Many of the question you're going to ask about Excel have previously been answered.

          If you haven't done it yet: It would also pay to take a course in the version of Excel that you are using.

          Thank you very much. You explains it very well. I got the mini system up, now its time for testing it. :)