Welcome Guest
( Log In | Register )
The time is now 5:27 pm
You last visited January 20, 2017, 5:13 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Formula - 6 Positions

Published:

Excel Formula Reference

6 Position Number in cell A1 (e.g. 012345)

Place each digit in their own position.

0 in cell C1

1 in cell D1

2 in cell E1

3 in cell F1

4 in cell G1

5 in cell H1 

=================================================== 

=INT(A1/100000)

=INT((A1-(C1*10000))/1000)

=INT((A1-((C1*100000)+(D1*10000)))/1000)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)))/100)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)+(F1*100)))/10)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)+(F1*100)+(G1*10)))

========================================================= 

Entry #100

Comments

1.
MzDuffleBagladyComment by MzDuffleBaglady - December 27, 2009, 12:42 pm
I would like to know the workouts for Missouri, thanx in advanced.

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.