← Back to level 2
Level 2Next
RAND
A medium random number formula that returns a decimal between 0 and 1.
Syntax
=RAND(...)Step-by-step explanation
- 1Understand the job that RAND solves before you type the formula.
- 2Build or select the cells and ranges that RAND needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Expecting it to stay fixed after recalculation
Using it in final reports without control
Confusing it with whole-number random formulas
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=RAND(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =RAND(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use RAND when you need a quick random value for testing, simulation, or sampling.
Match against the syntax block above.
Real-life use cases
SimulationsTest dataRandom sampling
Related formulas