- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 12:18 am
You last visited
April 24, 2024, 11:31 pm
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
(Locked)
Entry #504
Comments
This Blog entry currently has no comments.
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register