=RAND()*(65-1)+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. A sample result would be 56.90875721 or 1.34168538.
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. A sample result would be 56.90875721 or 1.34168538.
0 comments:
Post a Comment