Welcome Guest
Log In | Register )
You last visited December 3, 2016, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

Please help with simple Excel formula

Topic closed. 5 replies. Last post 11 years ago by calabs.

Page 1 of 1
PrintE-mailLink
calabs's avatar - bass fret.jpg

United States
Member #27050
November 26, 2005
40272 Posts
Offline
Posted: February 23, 2006, 4:29 pm - IP Logged

Can someone please help me with a simple Excel formula?

I'm looking to create a simple spreadsheet which incorporates additives, ie, the 123 method, or the 023, or one up/one down.  When I make the speadsheet, what I need to do is to drop the "tens" digit so it does not carry it over as per basic lottery math.

Thanks in advance for any help!

    cps10's avatar - Lottery-004.jpg
    The Carolinas - Charlotte
    United States
    Member #21627
    September 12, 2005
    4138 Posts
    Offline
    Posted: February 23, 2006, 4:36 pm - IP Logged

    That is a tough one...I would be interested to see that as well!

    The North Carolina Education Lottery - so much a joke that here are their mascots:

    Stooges

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: February 23, 2006, 6:42 pm - IP Logged

      Are you saying that you want the total sum of the combo (i.e, 897=24) and then to have a remainder of 4 be returned as the root sum? 

      L ttaL   T

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: February 23, 2006, 7:04 pm - IP Logged

        =RIGHT(AD2,1)*1

        Meant to say LDR

        If you meant the other side, just change right to left

        L ttaL   T

          hypersoniq's avatar - 8ball
          Pennsylvania
          United States
          Member #1340
          April 6, 2003
          2450 Posts
          Offline
          Posted: February 23, 2006, 7:08 pm - IP Logged

          it requires a conditional formula, built around a nested "IF" statement...

          say column A, Cell 1 had the number 9

          then say cell 1 of column B had your first "+1"

          the formula would be

          =IF(((A1+1)<10),(A1+1),((A1+1)-10))

          format is

          =IF(condition, do if true, do if false)

          so, the test, or condition, will see if A1+1 is less than 10

          if TRUE, just add 1 (7 becomes 8, 0 becomes 1 etc)

          if FALSE, add 1, then subtract 10 (9+1=10, then -10=0)

          change the 1 to whatever step you need, and this formula will keep the results in the realm of 0 to 9.

          with this formula in cell B1, simply autofill over in row 1 until you get the same number back, then the rundown is complete.

           

          good luck and let me know if this works for you.

          Playing more than one ticket per game is betting against yourself.

            calabs's avatar - bass fret.jpg

            United States
            Member #27050
            November 26, 2005
            40272 Posts
            Offline
            Posted: February 23, 2006, 10:31 pm - IP Logged

            Thanks hypersoniq - that did the trick!!! Thumbs UpThumbs Up

             

            thanks to all who replied!