Welcome Guest
Log In | Register )
You last visited December 10, 2016, 11:28 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help...

Topic closed. 15 replies. Last post 7 years ago by bigato1010.

Page 1 of 2
51
PrintE-mailLink
Avatar
New Member
Ho Chi Minh City
Viet Nam
Member #75840
June 13, 2009
9 Posts
Offline
Posted: June 22, 2009, 3:48 am - IP Logged

Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

Thank you in advance...

Rouge

    Avatar
    Gent
    Belgium
    Member #73987
    April 30, 2009
    33 Posts
    Offline
    Posted: June 22, 2009, 3:53 am - IP Logged

    In cell A1 and B1: 4 and 8

    In cell C1: =A1+B1 (resulting in '12')

    In cell D1: =INT(C1/10) (resulting in '1')

    In cell E1: =C1-D1*10 (resulting in '2') which is the information you need.

     

    Good luck :-)

      Avatar
      New Member
      Ho Chi Minh City
      Viet Nam
      Member #75840
      June 13, 2009
      9 Posts
      Offline
      Posted: June 22, 2009, 4:03 am - IP Logged

      GAMEBELGIUM,

      THANK YOU! that was extremely fast....

      Will be fine tuning my system and sharing it to all.... as always will be for free!

       

      Rouge

        diamondpalace's avatar - Untitled 2.jpg
        Dallas, TX
        United States
        Member #60284
        April 12, 2008
        3856 Posts
        Offline
        Posted: June 22, 2009, 4:40 am - IP Logged

        =MOD(A1+B1,10)

        A1 contain 4

        B1 contain 8

        put the formula above in C1 and it will create lotto math, best for pick 3 and pick 4.

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          49823 Posts
          Online
          Posted: June 22, 2009, 10:05 am - IP Logged

          Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

          Thank you in advance...

          Rouge

          http://www.lotterypost.com/thread/184639/1156663

          Lottery Post Search is Your Friend:

          http://www.lotterypost.com/search?q=%2BExcel%2BLottery%2BMath

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

            Jack-C's avatar - us
            San Diego, CA
            United States
            Member #61467
            May 24, 2008
            28146 Posts
            Offline
            Posted: June 22, 2009, 10:10 am - IP Logged

            =MOD(A1+B1,10)

            A1 contain 4

            B1 contain 8

            put the formula above in C1 and it will create lotto math, best for pick 3 and pick 4.

            I agree.  That's the way I do it.

              Raven62's avatar - binary
              New Jersey
              United States
              Member #17843
              June 28, 2005
              49823 Posts
              Online
              Posted: June 22, 2009, 11:11 am - IP Logged

              Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

              Thank you in advance...

              Rouge

              Formulating A Search:

              Search Box: Lottery Math

              Date Range: All History

              Forum: Mathematics

              http://www.lotterypost.com/search?q=Lottery+Math&t=all&f=12

              http://www.lotterypost.com/thread/154084/808572

              Lottery Post Search is Your Friend

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

                marcie's avatar - Lottery-060.jpg
                Ohio
                United States
                Member #49980
                February 21, 2007
                34190 Posts
                Online
                Posted: June 22, 2009, 11:49 am - IP Logged

                This is all new to me!! I am trying to understand it.

                http://www.lotterypost.com/thread/233413    Sun Smiley Popular numbers

                12345

                67890

                Use Mirror #'s Use prs. with your  Key* numbers the most Vivid thing in your dream go up or down on #'s.  Flip  6=9 `9=6  Bullseyes  0 or 1 for Pick 4 and the P. 5  Play the other part of doubles.  Do the Whole nine yards for a P. 4* P. 5*  or 0 thur 9  for P. 4  P. 5 from my dreams or hunches good Luck.. Write your Dreams down Play for 3 days.  Good Luck All.

                  Todd's avatar - Cylon 2.gif
                  Chief Bottle Washer
                  New Jersey
                  United States
                  Member #1
                  May 31, 2000
                  23275 Posts
                  Online
                  Posted: June 22, 2009, 2:35 pm - IP Logged

                  <Moved to Mathematics forum>

                  Please post in the appropriate forum ... thank you.

                    exclipse5's avatar - balar crowned.png
                    New Member

                    United States
                    Member #74643
                    May 17, 2009
                    7 Posts
                    Offline
                    Posted: June 24, 2009, 2:42 pm - IP Logged

                    Thank you both for posting this.  I have been doing my calculations by hand, then putting them on the excel sheet...  would be way more efficient to place the formula in a cell and let the calculations begin!

                      Rakster's avatar - praying hands.jpg
                      Saskatchewan
                      Canada
                      Member #19992
                      August 9, 2005
                      2867 Posts
                      Offline
                      Posted: June 29, 2009, 7:06 pm - IP Logged

                      Thank you both for posting this.  I have been doing my calculations by hand, then putting them on the excel sheet...  would be way more efficient to place the formula in a cell and let the calculations begin!

                      Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

                      Heres what I am looking for...

                      say the number is 3456

                      I want to first add 5 to the "3" to get a complete # 8456

                      then add 5 to second digit, 3956

                      then add 5 to third digit, 3406

                      then add 5 to last digit, 3461

                      but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

                      I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

                      We are all Lucky... just some of us don't realize it!

                        Avatar
                        New Mexico
                        United States
                        Member #58526
                        February 18, 2008
                        683 Posts
                        Offline
                        Posted: June 29, 2009, 7:32 pm - IP Logged

                        Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

                        Heres what I am looking for...

                        say the number is 3456

                        I want to first add 5 to the "3" to get a complete # 8456

                        then add 5 to second digit, 3956

                        then add 5 to third digit, 3406

                        then add 5 to last digit, 3461

                        but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

                        I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

                        let's say your 3456 is in column A (cell A1)

                         

                        put this formula in cell B1........     =MOD(MID(A1,1,1)+5,10)&MOD(MID(A1,2,1)+5,10)&MOD(MID(A1,3,1)+5,10)&MOD(MID(A1,4,1)+5,10)

                         

                        actually....I read your post again and that was not what your are looking for....you need this

                        put this in cell B1    =MOD(MID(A1,1,1)+5,10)&MID(A1,2,1)&MID(A1,3,1)&MID(A1,4,1)       this adds five to the first digit using lotto math

                        put this in cell C1     =MID(A1,1,1)&MOD(MID(A1,2,1)+5,10)&MID(A1,3,1)&MID(A1,4,1)       ...adds five to the second digit

                        put this in cell D1     =MID(A1,1,1)&MID(A1,2,1)&MOD(MID(A1,3,1)+5,10)&MID(A1,4,1)      ...adds five to the third digit

                        put this in cell E1     =MID(A1,1,1)&MID(A1,2,1)&MID(A1,3,1)&MOD(MID(A1,4,1)+5,10)      ...adds five to the fourth digit

                         

                        that should do what you want

                          Avatar
                          New Mexico
                          United States
                          Member #58526
                          February 18, 2008
                          683 Posts
                          Offline
                          Posted: June 29, 2009, 7:44 pm - IP Logged

                          Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

                          Heres what I am looking for...

                          say the number is 3456

                          I want to first add 5 to the "3" to get a complete # 8456

                          then add 5 to second digit, 3956

                          then add 5 to third digit, 3406

                          then add 5 to last digit, 3461

                          but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

                          I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

                          Okay, actually, I'm a little confused as to what you want.....

                          if you added five to each digit of your original 3456 and had the result in one cell wouldn't the resulting number be 8901????

                          if that's what you're looking for then use my first formula

                            Rakster's avatar - praying hands.jpg
                            Saskatchewan
                            Canada
                            Member #19992
                            August 9, 2005
                            2867 Posts
                            Offline
                            Posted: June 29, 2009, 9:02 pm - IP Logged

                            let's say your 3456 is in column A (cell A1)

                             

                            put this formula in cell B1........     =MOD(MID(A1,1,1)+5,10)&MOD(MID(A1,2,1)+5,10)&MOD(MID(A1,3,1)+5,10)&MOD(MID(A1,4,1)+5,10)

                             

                            actually....I read your post again and that was not what your are looking for....you need this

                            put this in cell B1    =MOD(MID(A1,1,1)+5,10)&MID(A1,2,1)&MID(A1,3,1)&MID(A1,4,1)       this adds five to the first digit using lotto math

                            put this in cell C1     =MID(A1,1,1)&MOD(MID(A1,2,1)+5,10)&MID(A1,3,1)&MID(A1,4,1)       ...adds five to the second digit

                            put this in cell D1     =MID(A1,1,1)&MID(A1,2,1)&MOD(MID(A1,3,1)+5,10)&MID(A1,4,1)      ...adds five to the third digit

                            put this in cell E1     =MID(A1,1,1)&MID(A1,2,1)&MID(A1,3,1)&MOD(MID(A1,4,1)+5,10)      ...adds five to the fourth digit

                             

                            that should do what you want

                            Thanks Madman!! This worked perfectly!

                            We are all Lucky... just some of us don't realize it!

                              Avatar
                              New Mexico
                              United States
                              Member #58526
                              February 18, 2008
                              683 Posts
                              Offline
                              Posted: June 29, 2009, 11:36 pm - IP Logged

                              Thanks Madman!! This worked perfectly!

                              No problem