Skip to main content

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 low and/or high; this will cause the least and greatest possible values to be the next integer greater than low and/or the next integer less than high, 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:


Excellentable generates the outcome:

A
B
1
RANDBETWEEN Formula
Value
2
RANDBETWEEN(1,1000)
517
3
RANDBETWEEN(-10,10)
0

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.