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

Excel Formulas Pick3 and Pick 4

Published:

Thanks to Hypersoniq for these formulas.

Excel formulas for converting Pick 3 to individual cells

=INT(B2/100)

=INT((B2-(C2*100))/10)

=INT((B2-((C2*100)+D2*10)))

 

Excel formulas for converting Pick 4 to individual cells

Assuming Cell C is where you enter the 4 digit combo...

in cell D ...  =INT(C2/1000)

in cell E ...  =INT((C2-(D2*1000))/100)

in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)

Entry #1

Comments

1.
Comment by Delta Draw - December 22, 2009, 4:22 am
Thanks Winsum!
I am want to learn how to make spreadsheets and these examples sure help. Just now learning how to read these function lines.
Delta Draw

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.