RANDBETWEENΒΆ

Creates a random value between min and max.

Syntax

=RANDBETWEEN(Min, Max)

Arguments

Name

Description

Min

Minimum value to return.

Max

Maximum value to return.

Return Value

Random number between minimum and maximum argument.

Example

Function

Result

Comment

=RANDBETWEEN(1, 10)

e.g.: 5

The return value can be any number between 1 and 10.