Random Numbers
 

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.

Random Numbers
 

use int;-

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

Mike

"Khanjohn" wrote:

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.

Random Numbers
 

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.

Random Numbers
 

Thank you MikeH that solved it.

"Khanjohn" wrote:

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.