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

Excel Help Needed

Topic closed. 4 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, 8:27 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)

I would like all 4 numbers to be added into 1 cell.

Any help would be greatly appreciated.

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

    Rakster's avatar - praying hands.jpg
    Saskatchewan
    Canada
    Member #19992
    August 9, 2005
    2867 Posts
    Offline
    Posted: March 22, 2008, 8:37 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)

    I would like all 4 numbers to be added into 1 cell.

    Any help would be greatly appreciated.

    Normal math

    EX:  9999

          +4321

           14320   

    I want it to add up without carrying...

    EX:   9999

          + 4321

             3210

    No carrying.  Is this possible to be done in excel and all entered into 1 cell?

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

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

      Rakster,

      Here is a link to an Excel file:

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

      Enter the pick 4 in cell A1

      The result (+5555 no carryover) 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:38 am - IP Logged

        Rakster,

        Here is a link to an Excel file:

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

        Enter the pick 4 in cell A1

        The result (+5555 no carryover) in cell L1

        Hope this helps!! 

        Thanks!

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

          Todd's avatar - Cylon 2.gif
          Chief Bottle Washer
          New Jersey
          United States
          Member #1
          May 31, 2000
          23259 Posts
          Offline
          Posted: March 22, 2008, 10:18 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!