generating random numbers

[Roger]

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]

Try

=INT(RAND()*20+1)

or if you have ATP installed

=RANDBETWEEN(1,20)

 

[Roger]

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




.