Kornilios Ampatzis/ April 19, 2019/ Functions

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:

Practice

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.

Share this Post