Welcome Guest
You last visited December 8, 2016, 10:57 am
All times shown are
Eastern Time (GMT-5:00)

# Three Digit's are easy

Topic closed. 90 replies. Last post 6 years ago by Todd.

 Page 4 of 7
Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: January 10, 2006, 9:13 pm - IP Logged

Can anyone help me with an Excel formula? What I am looking to do is create a 3-digit number from 3 1-digit numbers. This is what my spreadsheet looks like for example:

 P1 P2 P3 3Digit# 1 3 9 ??? 4 4 2 ???

What I want the B4 cell to do is write 139, and the B5 formula to be 442, etc.

=(b1*100)+(b2*10)+b3

The Carolinas - Charlotte
United States
Member #21627
September 12, 2005
4138 Posts
Offline
 Posted: January 10, 2006, 9:16 pm - IP Logged

Thanks CD...I can't believe I didn't think of that. Sheesh!

Switching between Fairfax, VA and Belgium
Belgium
Member #19287
July 29, 2005
2254 Posts
Offline
 Posted: January 10, 2006, 9:17 pm - IP Logged

will this work when the digit is 0?

Michigan
United States
Member #22395
September 24, 2005
1583 Posts
Offline
 Posted: January 10, 2006, 9:29 pm - IP Logged

casiecoco

You were just online 2 minutes ago!  Don't know if you are still online or not?  You come in here and basically light up the board with your very first visit.  Then you don't comment?  You don't offer anything more?  You can't do that!

...Well, you can, but...

Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: January 10, 2006, 9:31 pm - IP Logged

will this work when the digit is 0?

Yes.  I use it for all my wheels.

Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: January 10, 2006, 9:36 pm - IP Logged

will this work when the digit is 0?

Yes.  I use it for all my wheels.

The cells have to be formatted as "numbers" (no decimal places, of course).  And if there is a leading zero, it will be missing because with numbers in the "real" world leading zeros are not needed.  I take the column and copy it and then "paste special" into a column that is formatted as "text".  You paste "special" then click values.  Sort the second column, then type in any numbers that have a missing zero.  If you put in the missing zeros then sort, it will be all messed up!

Switching between Fairfax, VA and Belgium
Belgium
Member #19287
July 29, 2005
2254 Posts
Offline
 Posted: January 10, 2006, 9:37 pm - IP Logged

Is excel different in the USA?

Here the columns are A, B, C, ...

And the rows are the numbers...

here the formula would be
=(A1*100)+(B1*10)+C1

The Carolinas - Charlotte
United States
Member #21627
September 12, 2005
4138 Posts
Offline
 Posted: January 10, 2006, 9:55 pm - IP Logged

Yeah, you would have to format those cells as text and type in the missing zero or zeroes in the cell. I have now created a spreadsheet whereby you input the top 5 numbers, and it gives you the combinations for the best 3, best 4 and best 5. Pretty neat.

Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: January 10, 2006, 9:58 pm - IP Logged

Is excel different in the USA?

Here the columns are A, B, C, ...

And the rows are the numbers...

here the formula would be
=(A1*100)+(B1*10)+C1

Yes, you are right.

Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: January 11, 2006, 12:12 am - IP Logged

Here are my results from tonight's draws (13 states):

CalifDude Delaware Play 3 3-Way Box 6-9-6 6-6-9 \$80
CalifDude Illinois Daily 3 3-Way Box 8-4-8 4-8-8 \$80

Switching between Fairfax, VA and Belgium
Belgium
Member #19287
July 29, 2005
2254 Posts
Offline
 Posted: January 11, 2006, 2:30 pm - IP Logged

Using best 3 digits: 503, 550, 005, 553, 335, 330, 003

Using best 4 digits: 503, 506, 536, 036, 550, 005, 553, 335, 556, 665, 003, 330, 006, 660, 336, 663

Using best 5 digits: 503, 506, 504, 536, 534, 564, 036, 034, 064, 364, 550, 005, 553, 335, 556, 665, 554, 445, 003, 330, 006, 660, 004, 440, 336, 663, 334, 443, 664, 446

Midday:
01/09: 547
01/10: 282
01/11: 474

Result: still 0, perhaps they will come the second part of the week.

Michigan
United States
Member #22395
September 24, 2005
1583 Posts
Offline
 Posted: January 11, 2006, 3:47 pm - IP Logged

Just a note, to keep everyone on the same page...paurths results are for Michigan.

Switching between Fairfax, VA and Belgium
Belgium
Member #19287
July 29, 2005
2254 Posts
Offline
 Posted: January 11, 2006, 7:43 pm - IP Logged

Using best 3 digits: 503, 550, 005, 553, 335, 330, 003

Using best 4 digits: 503, 506, 536, 036, 550, 005, 553, 335, 556, 665, 003, 330, 006, 660, 336, 663

Using best 5 digits: 503, 506, 504, 536, 534, 564, 036, 034, 064, 364, 550, 005, 553, 335, 556, 665, 554, 445, 003, 330, 006, 660, 004, 440, 336, 663, 334, 443, 664, 446

Midday:
01/09: 547
01/10: 282
01/11: 474

Result: still 0, perhaps they will come the second part of the week.

Evening:
01/09: 339
01/10: 089
01/11: 988

Flint mi
United States
Member #29772
January 6, 2006
33 Posts
Offline
 Posted: January 11, 2006, 8:01 pm - IP Logged

I am going to predict 603,605,503,635 will fall in the Michigan 3 digit mid or eve on thursday or saturday

Switching between Fairfax, VA and Belgium
Belgium
Member #19287
July 29, 2005
2254 Posts
Offline
 Posted: January 11, 2006, 8:12 pm - IP Logged