RANDBETWEEN

The RANDBETWEEN function returns a random integer between two specified values. It generates a number within the defined range each time the function is evaluated and is commonly used in simulations, sampling, and testing scenarios where random data is required.

Syntax

RANDBETWEEN(value1, value2)

Arguments

• value1: The smallest integer that RANDBETWEEN returns.

• value2: The largest integer that RANDBETWEEN returns.

Return value

Returns a random integer between the specified minimum and maximum values.

Example

RANDBETWEEN(52, 110)

In this example, the Rand Between measure is created using the RANDBETWEEN function, which generates a random integer between 52 and 110.

Excel equivalent

RANDBETWEEN