Random number formula

=RAND()
The excel formula above will display random numbers with decimal places, primarily between 0 and 1. Which as you fill it down the excel.spreadsheet will generate random numbers. Such as, 0.13452789 and 0.97856453.

Read More..

Random number genarator formula for specific range

=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.

Read More..