Random Number Generator
Iım aware of the function ³=RAND()², that produces the numbers between 0 and
1, but Iım just trying to create a cell formula that produces an evenly
distributed number between two arbitrary values ....
Assuming I need between 1 and 10 (i.e., 1,2,3,4,5,6,7,8,9 or 10), how would
I achieve this without getting a skewed result?
I was thinking of =TRUNC((RAND()*10+1),0) ? Now thatıs just for between 1
and 10
Is there a better way of doing this * help!
Brad.)
|