View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad[_13_] Brad[_13_] is offline
external usenet poster
 
Posts: 8
Default 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.)