=ROUND(RAND() * (65-1) +1,0)
The excel formula above will generate random numbers between 1 and 65 as you fill it down an excel spreadsheet. The (65-1)+1 bit tells excel to only select numbers between 1 and 65. Simplified it would be (higher number - lower number) + lower number. The RAND()* part randomises the numbers in the range. The ROUND(...,0) part rounds the random numbers to zero decimal place. A sample result would be 57 or 1.
The excel formula above will generate random numbers between 1 and 65 as you fill it down an excel spreadsheet. The (65-1)+1 bit tells excel to only select numbers between 1 and 65. Simplified it would be (higher number - lower number) + lower number. The RAND()* part randomises the numbers in the range. The ROUND(...,0) part rounds the random numbers to zero decimal place. A sample result would be 57 or 1.
0 comments:
Post a Comment