RANDBETWEEN

Returns a uniformly random integer between two values, inclusive.

Sample Usage

RANDBETWEEN(5,10)
RANDBETWEEN(A4,A5)

Syntax

RANDBETWEEN(number1, number2)

  • number1 - The low end of the range.
  • number2 - The high end of the range.

Examples

RANDBETWEEN(5,10) can return any value between 5 and 10, inclusive.
RANDBETWEEN(A4,A5) returns a random number between A4 and A5, inclusive.