RANDBETWEEN

The RANDBETWEEN function returns a random number between two values.

Syntax

randbetween(value1,value2)

Arguments

value1 - Required. The smallest integer RANDBETWEEN will return.

value2 - Required. The largest integer RANDBETWEEN will return.

Example

randbetween(0,100)

Returns a random number between 0 and 100

Excel equivalent

RANDBETWEEN