Welcome Guest
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
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!

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!

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:

Enter your Pick 4 combo in cell A1

The result will be in cell L1

Hope this helps!!

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!

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!

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