Welcome Guest
You last visited April 28, 2017, 11:47 am
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 5 replies. Last post 11 years ago by calabs.

 Page 1 of 1

United States
Member #27050
November 26, 2005
40273 Posts
Offline
 Posted: February 23, 2006, 4:29 pm - IP Logged

I'm looking to create a simple spreadsheet which incorporates additives, ie, the 123 method, or the 023, or one up/one down.  When I make the speadsheet, what I need to do is to drop the "tens" digit so it does not carry it over as per basic lottery math.

Thanks in advance for any help!

The Carolinas - Charlotte
United States
Member #21627
September 12, 2005
4138 Posts
Offline
 Posted: February 23, 2006, 4:36 pm - IP Logged

That is a tough one...I would be interested to see that as well!

The North Carolina Education Lottery - so much a joke that here are their mascots:

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: February 23, 2006, 6:42 pm - IP Logged

Are you saying that you want the total sum of the combo (i.e, 897=24) and then to have a remainder of 4 be returned as the root sum?

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: February 23, 2006, 7:04 pm - IP Logged

Meant to say LDR

If you meant the other side, just change right to left

L ttaL   T

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: February 23, 2006, 7:08 pm - IP Logged

it requires a conditional formula, built around a nested "IF" statement...

say column A, Cell 1 had the number 9

the formula would be

=IF(((A1+1)<10),(A1+1),((A1+1)-10))

format is

=IF(condition, do if true, do if false)

so, the test, or condition, will see if A1+1 is less than 10

if TRUE, just add 1 (7 becomes 8, 0 becomes 1 etc)

if FALSE, add 1, then subtract 10 (9+1=10, then -10=0)

change the 1 to whatever step you need, and this formula will keep the results in the realm of 0 to 9.

with this formula in cell B1, simply autofill over in row 1 until you get the same number back, then the rundown is complete.

good luck and let me know if this works for you.

Playing more than one ticket per game is betting against yourself.

United States
Member #27050
November 26, 2005
40273 Posts
Offline
 Posted: February 23, 2006, 10:31 pm - IP Logged

Thanks hypersoniq - that did the trick!!!

thanks to all who replied!

 Page 1 of 1