Excel RAND Function (Random Decimal 0–1) – Examples & Practice
Practice the Excel RAND function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Generate a random decimal number from 0 to less than 1.
Formula Syntax
=RAND()
- (no arguments): RAND takes no inputs.
What it does
RAND generates a uniform random decimal between 0 and 1 (exclusive of 1 in practice). It is volatile and recalculates as the workbook recalculates.
Excel RAND Function Examples
Random decimal
=RAND()
Returns a number from 0 up to (but not including) 1.
Random integer 1–10
=INT(RAND()*10)+1
A common pattern for quick demos.
numeric-practice-sheet.xlsx
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Input 1 | 120 |
| 3 | Input 2 | -45 |
| 4 | Input 3 | 560.25 |
| 5 | Input 4 | 225.8 |
| 6 | Input 5 | 90 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Paste values after sampling to lock results.
- Avoid volatile randomness in finalized reports.
- Pair with statistical functions carefully due to recalculation.
RAND Function Use Cases
- Simulations and Monte Carlo prototypes
- Randomize study or QA samples
- Shuffle-like behavior with helper columns
- Testing formulas under varying inputs
- Teaching probability basics
Common mistakes - RAND function not working
- Expecting stable results without paste-values
- Using RAND in production audits without controls
- Forgetting recalculation impact on shared files
- Using RAND when RANDBETWEEN is clearer for integers
- Not documenting volatility for teammates
FAQ
Does RAND recalculate?
Yes. Volatile functions recalculate when the workbook changes depending on calculation settings.
How do I freeze random values?
Copy and Paste Values, or replace formulas after generation.
RAND vs RANDBETWEEN?
RAND returns decimals in [0,1). RANDBETWEEN returns integers in a range.
Can I seed RAND?
Excel does not expose classic seeding for RAND; use add-ins or VBA for reproducible streams.
Why did my random sample change?
Any sheet recalculation can change volatile random outputs.
Comparison
| Tool | Output |
|---|---|
| RAND | Decimal in [0,1) |
| RANDBETWEEN | Integer range |
Example
=RAND()
Advanced examples
Random rows without repeats
Combine SORTBY with RANDARRAY (modern Excel) for larger randomization patterns beyond a single RAND cell.