Welcome Guest
( Log In | Register )
The time is now 5:53 am
You last visited January 18, 2017, 5:31 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 ____ ____ ____ ____ ____


Entry #503

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.