RANDBETWEEN

Returns a random integer number in the specified range.

Syntax

RANDBETWEEN( Integer bottom, Integer top ) → Integer

Parameters

bottom

Required. The smallest value the function can return.

top

Required. The largest value the function can return.

Remarks

The function returns a random value in the interval [bottom…top]. If bottom is greater than top, RANDBETWEEN returns the #NUM! error value. If the specified arguments are not integer, they are automatically truncated.

Example

Formula

=RANDBETWEEN(1,100)
=RANDBETWEEN(-1,1)

See Also

Function Reference
RAND Function