Random Numbers


Posted by Donna Rott on November 04, 2001 2:45 PM

My question is how do I set up a formula to
randomly select a number between 1 - 50? I need
five (5) random numbers.

The process is needed to ramdomly
select a person to review their work on a daily basis.

Please help, thank.

Donna


Posted by Jaime on November 04, 2001 3:09 PM

=INT(RAND()*50)+1

This should do it.



Posted by Richard S on November 04, 2001 5:54 PM

Or RANDBETWEEN(1,50) (nt)