Welcome Guest
You last visited March 26, 2019, 11:22 am
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 4 replies. Last post 10 years ago by diamondpalace.

 Page 1 of 1

United States
Member #60282
April 12, 2008
3857 Posts
Offline
 Posted: November 17, 2008, 11:19 am - IP Logged

Would like some help on excel addition using lotto math, not traditional math. If I where to add 2 to 9, would like the answer to be 1 instead of 11. How can I program this in excel? Thanks.

Killer's Cove
United States
Member #57
December 17, 2001
6040 Posts
Offline
 Posted: November 17, 2008, 12:06 pm - IP Logged

Would like some help on excel addition using lotto math, not traditional math. If I where to add 2 to 9, would like the answer to be 1 instead of 11. How can I program this in excel? Thanks.

=MOD(2+9,10)

Life i\$ good !  bg

United States
Member #60282
April 12, 2008
3857 Posts
Offline
 Posted: November 17, 2008, 1:30 pm - IP Logged

=MOD(2+9,10)

Thanks Bluegrass. How can I program a cell to +222 to the selected cell for the SUM to lotto math?

25
New Jersey
United States
Member #17842
June 28, 2005
98404 Posts
Online
 Posted: November 17, 2008, 2:48 pm - IP Logged

Thanks Bluegrass. How can I program a cell to +222 to the selected cell for the SUM to lotto math?

Rather than combining the three digits (ie: 345) it makes it easier to keep the three digits in separate cells (ie: a1=3 b1=4 c1=5): Otherwise you'll have to separate the combined digits to perform the (+/-) operation and then combine them again.

Try this:
a1=3 b1=4 c1=5 e1=2 f1=2 g1=2

in a2 put
=mod(a1+e1,10)

in b2 put
=mod(b1+f1,10)

in c2 put
=mod(c1+g1,10)

Lottery Post Search is Your Friend:

https://www.lotterypost.com/search?q=excel&t=all

If you haven't done it yet: It would also pay to take a course in the version of Excel that you are using.

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

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

United States
Member #60282
April 12, 2008
3857 Posts
Offline
 Posted: November 17, 2008, 3:36 pm - IP Logged

Rather than combining the three digits (ie: 345) it makes it easier to keep the three digits in separate cells (ie: a1=3 b1=4 c1=5): Otherwise you'll have to separate the combined digits to perform the (+/-) operation and then combine them again.

Try this:
a1=3 b1=4 c1=5 e1=2 f1=2 g1=2

in a2 put
=mod(a1+e1,10)

in b2 put
=mod(b1+f1,10)

in c2 put
=mod(c1+g1,10)

Lottery Post Search is Your Friend:

https://www.lotterypost.com/search?q=excel&t=all