Google Sheets
RAND function in Google Sheets
Returns a random number between 0 inclusive and 1 exclusive.
=RAND()RAND examples
Formulas you'll actually reuse.
A random decimal from 0 up to 1 — recalculates on every edit:
=RAND()Pick roughly 10% of rows for a spot check (paste as values to freeze them):
=IF(RAND() < 0.1, "Audit", "")
RAND in Excel
Same name — your formula ports as-is.
Try RAND in the playground
Edit the example — nothing to install.
Preloaded with the RAND formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel