Skip to main content

RAND

The RAND function returns a random decimal number that is greater than or equal to 0 and less than 1.

This function can be useful for data generation, modeling, and other tasks where randomness is required.

Syntax​

RAND()

No arguments are allowed for this function.

Example of use​

If you want to get a random number, use

=RAND()

The function will return a random value, for example, 0.123456789.

Notes​

  • Every time you open a file, change the value of any cell, insert or delete rows or columns, rename or move a sheet, manually recalculate data, or change the calculation mode from “Calculate manually” to “Calculate automatically”, the RAND function will generate a new random number.
  • If you want to record a random number, you can copy the cell with the formula and paste only the value.