generating random numbers

Roger · Sep 15, 2003

Is there a way (or formula) to generate a random number in
a cell? If so, can I specify the range I want the random
number to fall into, e.g., 1 through 6, 0 through 9, 1
through 20?

Thanks.

Roger

Peo Sjoblom · Sep 15, 2003

Try

=INT(RAND()*20+1)

or if you have ATP installed

=RANDBETWEEN(1,20)

Roger · Sep 17, 2003

Peo,

Great, this works! Thanks.

Roger

-----Original Message-----
Try

=INT(RAND()*20+1)

or if you have ATP installed

=RANDBETWEEN(1,20)

--

Regards,

Peo Sjoblom

.