Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random number Generator | New Users to Excel | |||
Random number generator | Excel Worksheet Functions | |||
random number generator | Excel Discussion (Misc queries) | |||
Random Number Generator | Excel Worksheet Functions | |||
random number generator | Excel Discussion (Misc queries) |