RANDBETWEEN

Returns a random integer within the specified range.

Syntax

RANDBETWEEN(from,to)

  • from - minimal integer for random number range.

  • to - maximum integer for random number range.

Sample Usage

RANDBETWEEN(1, 5)

Return Value

  • The random number, always >= from and <= to.

Notes

It's also possible to create a LAZY CELL using this function by putting ? symbol before the formula, e.g. =?RANDBETWEEN(). It'll return random number which will change any time the cell's pressed.

See Also

PreviousSERIESNextROUND

Last updated

Was this helpful?