Random Numbers

[Guest]

I know how to use =Rand() but i need to generate numbers between 2 and 100 or
2 and 20 etc and want whole numbers not 4.6789678. How is this done
please..Brain has quit functions after being up so late.

 

[Guest]

use int;-

=INT(RAND()*(100-1)+1)

Mike

 

[Roger Whitehead]

See OLH for Rnd - there is an example for ding what you require.
HTH
Roger

 

[Guest]

Thank you MikeH that solved it.