RAND
Returns a random number between 0 and 1.
Math & TrigonometryMath Basics
What it does
Generates a random decimal between 0 and 1.
Syntax
RAND()
Examples
Random Number
Generate random.
FORMULA
=RAND()
RESULT
0.5
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | (Random) |
Returns a random number between 0 and 1.
Generates a random decimal between 0 and 1.
RAND()
Generate random.
=RAND()
| A | |
|---|---|
| 1 | Val |
| 2 | (Random) |