Excel and Lotto Math

Reply #8

Best Picks — Sat, 11 Sep 2010 23:10:57 GMT

thank you, this is just what i was looking for

Reply #7

jimmy4164 — Tue, 31 Aug 2010 14:59:36 GMT

I think LotteryPost might benefit from adding a Facebook Like button. It would save bandwidth and disk space.

In the case of your post above:

Like

Reply #6

jwhou — Mon, 30 Aug 2010 00:02:21 GMT

Just treat each digit separately and take a modulus 10 of the sum. It isn't really 079 and 444 but each digit is a separate number so it's 0-7-9 and 4-4-4 hence the lotto math result would in real math be (0+4)%10 - (7+4)%10 - (9+4)%10 In Excel, the modulus function is mod(num,divisor) hence if A1 B1 C1 was 079 and A2 B2 C2 was 444 then you would have A3=mod((A1+A2),10) B3=mod((B1+B2),10) and C3=mod((C1+C2),10)

This is certainly not a stumper. Just grade school stuff from as soon as you learn... [ More ]

Reply #5

Sheela — Sun, 22 Aug 2010 14:32:58 GMT

Yes, please. What was the formula you came up with. I am trying to do the same thing myself.

Thanks for your help.

Reply #4

Raven62 — Sat, 21 Aug 2010 22:31:11 GMT

What was the Formula you came up with

Reply #3

Rakster — Sat, 21 Aug 2010 18:37:14 GMT

refered back to an excel program i had created a long time ago and them tinkered around with different things until it gave me whay i was looking for.... very hard on the head after a while...lol

Reply #2

Raven62 — Sat, 21 Aug 2010 18:09:58 GMT

That's Good: How did you do it

Reply #1

Rakster — Sat, 21 Aug 2010 15:40:13 GMT

I figured it out..

Excel and Lotto Math

Rakster — Sat, 21 Aug 2010 00:44:31 GMT

How does one formulate lotto math in excel?

Say I want to add 079 plus 444

In real math you get 523

in lotto math you get 413

Is there an Excel formula on can use to automatically get the 413?

Your help and expertice is greatly appreciated