Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
RAND
RAND generates a uniformly distributed random number in [0, 1). It takes no arguments and recalculates on every sheet change. Use it to assign random order, simulate probabilities, or drive Monte Carlo models. For a fixed random value, copy-paste as values.
Excel
=RAND()Google Sheets
=RAND()✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Item | Random Score |
| Alpha | |
| Beta | |
| Gamma | |
| Delta |
=RAND()→0.6201367844
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1RAND() takes no arguments — just call it with empty parentheses.
- 2The result is a decimal between 0 and 1 (e.g. 0.4723).
- 3Scale to a range with =RAND()*(max-min)+min, or use RANDBETWEEN for whole numbers.