- 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 4:15 am
You last visited
April 23, 2024, 3:03 am
All times shown are
Eastern Time (GMT-5:00)
Splitting P3/P4 numbers
Published:
To split a p3 or p4 number into component parts
P3: full number in cell A1: e.g. 234
formula in B1: = INT(A1/100)
formula in C1: = INT(MOD(A1,100)/10)
formula in D1: = MOD(A1,10)
P4: full number in cell A3: e.g. 4321
formula in B3: = INT(A3/1000)
formula in C3: = INT(MOD(A3,1000)/100)
formula in D3: = INT(MOD(A3,100)/10)
formula in E3: = MOD(A3,10)
| ____ | A | B | C | D | E |
| 1 | 234 | 2 | 3 | 4 | |
| 2 | |||||
| 3 | 4321 | 4 | 3 | 2 | 1 |
| 4 | ____ | ____ | ____ | ____ | ____ |
(Locked)
Entry #503
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