These docs are for v1.0. Click to read the latest docs for v1.2.

RANDBETWEEN

Returns a random integer between min and max (inclusive).

Syntax

=RANDBETWEEN(min, max)

Arguments

ArgumentTypeDescription
minNumberThe minimum value that the random integer can be
maxNumberThe maximum value that the random integer can be

Example

=RANDBETWEEN(1, 5)3