Returns a random number between 0 inclusive and 1 exclusive. Learn more
In Google Sheets, the function RAND is a built-in function used to generate a random decimal number between 0 and 1.
Here's how the RAND() function works:
The RAND() function does not require any arguments. It is used as a standalone function. Each time the spreadsheet recalculates or when you make changes to the sheet, the RAND() function recalculates and generates a new random number. When you use the RAND() function, a random decimal number greater than or equal to 0 and less than 1 is generated. The generated number can include up to 15 decimal places.
For example, if you use the formula =RAND(), it will produce a different random decimal number each time it recalculates. The generated number could be 0.123456, 0.789012, or any other value between 0 and 1.
The RAND() function is commonly used to generate random values for simulations, random selections, or any situation that requires randomization within a spreadsheet.