RANDBETWEEN
Returns a random number between the numbers you specify.
Math & TrigonometryMath Basics
What it does
Generates a random integer between min and max.
Syntax
RANDBETWEEN(bottom, top)
Arguments
bottom(number) — Lower bound.top(number) — Upper bound.
Examples
Random Int
Random between 1 and 100.
FORMULA
=RANDBETWEEN(1, 100)
RESULT
42
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | (Random) |