How do I use RANDBETWEEN in Excel?
Use RANDBETWEEN when you want to generate a random number between two limits. Enter Bottom value, Top value in that order, then add optional arguments when needed.
Excel Function
RANDBETWEEN
Returns random integer between two numbers.
RANDBETWEEN(bottom, top)Arguments
bottom
RequiredEnter a numeric value.
top
RequiredEnter a numeric value.
Practice Preview
Use RANDBETWEEN to return one random integer between 1 and 100 (the value changes on every recalculation).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=RANDBETWEEN(1, 100)Example result (changes on every recalculation)
50
Practice This Function
RANDBETWEEN FAQ
Where can I practice RANDBETWEEN?
Use the "Start Function Practice" button to jump straight into RANDBETWEEN drills.
What arguments does RANDBETWEEN use?
The main arguments are Bottom value, Top value. Enter them in order.