The RAND function returns an evenly distributed random real number greater than or equal to 0 and less than 1.
Note: RAND takes no arguments but requires empty parentheses.
- A new random real number is returned every time the worksheet is calculated.
- If you want to use RAND to generate a random number but don’t want the numbers to change every time the cell is calculated, enter =RAND() in the formula bar, and then press F9 to change the formula to a random number.
|2||=RAND()||varies||A random number ≥ 0 and less than 1|
|3||=RAND()*100||varies||A random number ≥ 0 and less than 100|
|4||=RAND()*10+10||varies||A random number ≥ 10 and less than 20|
|5||=RAND()*(20-10)+10||varies||Same formula as in A4 but written as RAND()*(b-a)+a|
Note: Although the number generated is between 0 and 1, you can use the function to generate a random real number between any two supplied limits a and b, using the formula:=RAND()*(b-a)+a