Creating Random Generator in EXCEL

Published: January 23, 2005, 1:37 pm

For 3 separate column (A1,B1,C1), Type/copy normula in each:

=MOD((INT(RAND()*10)+1),10)

For 1 column, type:

=INT(RAND()*999)

For other games, MegaMillion, etc:

=INT(RAND()*52)+1

Where the "52" is, for any game, just insert the number of balls used in the drawing, and copy normula to 4,5 or 6 columns.

To change (generate) the pickings,

Click F9

Everytime you use and X out, it will ask if you want to save. No need to do this, except the FIRST time.

Good luck!

Entry #12

Comments

This Blog entry currently has no comments.