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


"Khanjohn" wrote in message
...
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.