Welcome Guest
You last visited January 17, 2017, 8:34 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
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!

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!

Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Online
 Posted: March 22, 2008, 8:57 am - IP Logged

Rakster,

Here is a link to an Excel file:

Enter the pick 4 in cell A1

The result (+5555 no carryover) in cell L1

Hope this helps!!

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:

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!

Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23348 Posts
Online
 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