RANDBETWEEN
Syntax:
RANDBETWEEN ( lower-bound , upper-bound )
Description: Computes a random integer number in the range lower-bound–upper-bound. A new random integer number is returned every time the cell's value is calculated.
Arguments:
Name |
Type |
Description |
---|---|---|
lower-bound |
number |
The smallest integer that will be returned. |
upper-bound |
number |
The largest integer that will be returned. |
Return Type and Value: number – A random integer number in the range specified.
However, if lower-bound is greater than upper-bound, #NUM!
is returned.
example: