USA Mega

Lottery Places

The time is now 4:29 am

You last visited
May 10, 2024, 4:23 am

All times shown are
Eastern Time (GMT-5:00)

Home › Blogs › winsumloosesum's Blog › Excel Formulas Pick3 and Pick 4

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

Avatar Delta Draw -
#1
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

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

Guest