RANDBETWEEN
Definiton
Returns a uniformly random integer between two values, inclusive.
Sample Usage
Syntax
RANDBETWEEN(low, high)
low- The low end of the random range.high- The high end of the random range.
Notes
- Values with decimal parts may be used for
lowand/orhigh; this will cause the least and greatest possible values to be the next integer greater thanlowand/or the next integer less thanhigh, respectively.
See Also
RAND: Returns a random number between 0 inclusive and 1 exclusive.
In order to use the RANDBETWEEN formula, start with your edited Excellentable. Then type in the RANDBETWEEN Formula in the area you would like to display the outcome:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
