It returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.
The syntax of the function is the following:
RAND()
To generate a random real number between a and b, use: RAND()*(b-a)+a
To generate a random integer number between two numbers use the RANDBETWEEN function.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the RAND function:
In the cells B2:B10 insert random numbers between 0 and 1 using the RAND function.
In the cells C2:C10 insert random numbers between 10 and 20 using the RAND function.