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

Excel Help needed

Topic closed. 5 replies. Last post 9 years ago by Todd.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: March 22, 2008, 12:35 am - IP Logged

If I have a number like 9847 and I want to add 5555 to it WITHOUT having it carry any numbers, what formula would I type in?

I want to use Lotto math not regular math.

Example: 9847+5555 = 15402 --> I want it to read 4392 (9+5 = 1 4, 8+5 = 1 3, 4+5 = 9, 7+5 = 1 2)

Any help would be greatly appreciated.

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

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49699 Posts
    Offline
    Posted: March 22, 2008, 9:05 am - IP Logged

    Excel formulas for converting Pick 4 to individual cells

    Assuming Cell C is where you enter the 4 digit combo...

    in cell D ...  =INT(C2/1000)

    in cell E ...  =INT((C2-(D2*1000))/100)

    in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)

    in cell G ...  =INT((C2-((D2*1000)+(E2*100)+(F2*10)))/1)

    (I have draw number and draw date in columns A and B)

    Excel formulas for adding 5 to each Pick 4 digit

    in cell H ... =MOD(D2+5,10)

    in cell I ... =MOD(E2+5,10)

    in cell J ... =MOD(F2+5,10)

    in cell K ... =MOD(G2+5,10)

    Excel formula for converting multiple cells to one Pick 4 cell

    in cell L ... =CONCATENATE(H2,I2,J2,K2)

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

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: March 22, 2008, 9:30 am - IP Logged

      Here is a link to an Excel file:

      http://www.badongo.com/file/8408117

      Enter your Pick 4 combo in cell A1

      The result will be in cell L1

      Hope this helps!! 

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        Member #19992
        August 9, 2005
        2867 Posts
        Offline
        Posted: March 22, 2008, 9:44 am - IP Logged

        Thank you, thank you, thank you!!!!

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

          Avatar
          EAST COAST, USA
          United States
          Member #49428
          January 31, 2007
          553 Posts
          Offline
          Posted: March 22, 2008, 10:04 am - IP Logged

          Excel formulas for converting Pick 4 to individual cells

          Assuming Cell C is where you enter the 4 digit combo...

          in cell D ...  =INT(C2/1000)

          in cell E ...  =INT((C2-(D2*1000))/100)

          in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)

          in cell G ...  =INT((C2-((D2*1000)+(E2*100)+(F2*10)))/1)

          (I have draw number and draw date in columns A and B)

          Excel formulas for adding 5 to each Pick 4 digit

          in cell H ... =MOD(D2+5,10)

          in cell I ... =MOD(E2+5,10)

          in cell J ... =MOD(F2+5,10)

          in cell K ... =MOD(G2+5,10)

          Excel formula for converting multiple cells to one Pick 4 cell

          in cell L ... =CONCATENATE(H2,I2,J2,K2)

          Great Job!

            Todd's avatar - Cylon 2.gif
            Chief Bottle Washer
            New Jersey
            United States
            Member #1
            May 31, 2000
            23261 Posts
            Online
            Posted: March 22, 2008, 10:16 am - IP Logged

            Do not post the same topic in more than one forum.  That is called double-posting, and is a close cousin to spamming.

             

            Check the State Lottery Report Card
            What grade did your lottery earn?

             

            Sign the Petition for True Lottery Drawings
            Help eliminate computerized drawings!