How do I use RAND in Excel?
Use RAND when you want to generate a random decimal. It works without extra arguments, so you can enter it as-is.
Excel Function
RAND
Returns random number between 0 and 1.
RAND()Arguments
Practice Preview
Use RAND to Returns random number between 0 and 1 (no arguments required).
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)
=RAND()Result
0.5
Practice This Function
RAND FAQ
Where can I practice RAND?
Use the "Start Function Practice" button to jump straight into RAND drills.
What arguments does RAND use?
The arguments depend on the formula. Enter them in order.