RAND function

The RAND function is one of the math and trigonometry functions. The function returns a random number greater than or equal to 0 and less than 1. It does not require any argument.

Syntax

RAND()

Notes

How to apply the RAND function.

Examples

The figure below displays the result returned by the RAND function.

To generate a random real number between a and b, use the following formula replacing a and b with your own values: =RAND()*(b-a)+a