Welcome Guest
( Log In | Register )
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

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.