Welcome Guest
You last visited April 23, 2017, 7:45 am
All times shown are
Eastern Time (GMT-5:00)

# Excel Help Needed

Topic closed. 3 replies. Last post 10 years ago by GASMETERGUY.

 Page 1 of 1
Member #19992
August 9, 2005
2871 Posts
Offline
 Posted: April 5, 2007, 8:33 pm - IP Logged

I do not know much about excel... self taught on what I do know, so I am hoping there is someone here that can help me.

I was wondering if someone can tell me a formula for doing a rundown but yet still having the zero appear in its first digit spot if need be. Also its got to be designed to use lottery math where 6 and 7 = 3 and NOT carry the 1 over.

So the rundown would be like so..

654

543

432

321

210

109

How can make a formula that would automatically generate the sets once the initial 3 numbers were put in place to start the sequence. (Notice the 0 to 9.. can this be done without borrowing?)

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

New Jersey
United States
Member #17843
June 28, 2005
55865 Posts
Online
 Posted: April 5, 2007, 8:54 pm - IP Logged

Lottery Math
A2=6 B2=7 C2=MOD(A2+B2,10)

A mind once stretched by a new idea never returns to its original dimensions!

Member #19992
August 9, 2005
2871 Posts
Offline
 Posted: April 5, 2007, 11:03 pm - IP Logged

Lottery Math
A2=6 B2=7 C2=MOD(A2+B2,10)

Thanks Raven

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

NASHVILLE, TENN
United States
Member #33372
February 20, 2006
1044 Posts
Offline
 Posted: April 6, 2007, 8:52 pm - IP Logged

Lottery Math
A2=6 B2=7 C2=MOD(A2+B2,10)

We need a "Computer Program" forum.

 Page 1 of 1