Welcome Guest
The time is now 11:25 am
You last visited January 17, 2017, 9:54 am
All times shown are
Eastern Time (GMT-5:00)

# Lottery Math for P3/P4

Published:

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
Entry #504