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 the result with these settings (Bottom value: 1, Top value: 100).
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)Result
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.