← Back to level 2
Level 2Next
RANDBETWEEN
A medium random number formula for whole numbers between two limits.
Syntax
=RANDBETWEEN(...)Step-by-step explanation
- 1Understand the job that RANDBETWEEN solves before you type the formula.
- 2Build or select the cells and ranges that RANDBETWEEN needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Swapping the minimum and maximum values
Forgetting that results recalculate
Using it where repeatable data is needed
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=RANDBETWEEN(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =RANDBETWEEN(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use RANDBETWEEN when you need a random integer within a fixed range.
Match against the syntax block above.