/blogentry/51835 time*treat's Blog: Lottery Math for P3/P4 en-us Lottery Post RSS Generator /blogentry/51835 /blogentry/51835 Mon, 28 Feb 2011 17:38:37 GMT time*treat Non-carrying math

P3: 987 + 456 = 333

P4: 9557 + 1576 = 0023

(use custon formatting to show leading zeroes)

Begin by splitting the old numbers ... sum by column, mod sums by 10, then place the new numbers.

* D E F G H

2

3 987 = INT(D3/100) = INT(MOD(D3,100)/10) = MOD(D3,10)

4 456 = INT(D4/100) = INT(MOD(D4,100)/10) = MOD(D4,10)

5 =E5*100+F5*10+G5 =MOD(E3+E4,10) =MOD(F3+F4,10) =MOD(G3+G4,10)

6

7

8 9557 = INT(D8/1000) = INT(MOD(D8,1000)/100) = INT(MOD(D8,100)/10) = MOD(D8,10)

9 1576 = INT(D9/1000) = INT(MOD(D9,1000)/100) = INT(MOD(D9,100)/10) = MOD(D9,10)

10 =E10*1000+F10*100+G10*10+H10 =MOD(E8+E9,10) =MOD(F8+F9,10) =MOD(G8+G9,10) =MOD(H8+H9,10)

Visually =E10 F10 G10 H10 gives the same result as =E10*1000+F10*100+G10*10+H10.

The difference is the first is a text string, the second is still a number. You can do further calculations on the second.

*Sometimes you're not using cell A1

=E5*100+F5*10+G5

... [ More ]

]]> Blog Entry time*treat https://www.lotterypost.com/blogentry/51835