- 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 7:40 am
You last visited
April 23, 2024, 7:27 am
All times shown are
Eastern Time (GMT-5:00)
Excel formula for Random picker
Published:
Updated:
To produce 1 set of three numbers, type formula in Column (A):
=INT(RAND()*999)
Using 3 columns to produce 1# in each, type this formula, then copy to (B) (C):
=MOD((INT(RAND()*10)+1),10)
To change/generate a different answer, Click F9. You can hold F9 down or just touch it once. It will ask each time you open it, if you want to save…only need to save the FIRST time.
For other lottery games, you can use this formula…just change the “53” to match the number of balls used in the game you are working with:
=INT(RAND()*53)+1
If it is 5 balls, plus a bonus: insert formula into 5 columns and in 6th-change number to match balls for the Bonus drawing, if different from the first ones.
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