Calc RANDBETWEEN function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The RANDBETWEEN function is used to generate a random integer (a whole number) between two specified values, which can be useful in a variety of applications. When you use this function, it picks a random whole number that falls between the bottom and top values you specify. Each time the function is activated or the data is refreshed, it generates a new random number.

Syntax

RANDBETWEEN(bottom, top)

The RANDBETWEEN function syntax has the following arguments:

• bottom: Required. The smallest integer RANDBETWEEN will return. This is the lowest number that can be generated. It's the starting point of your random range.
• top: Required. The largest integer RANDBETWEEN will return. This is the highest number that can be generated. It sets the upper limit of your random range.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc ABS function
• Calc AVERAGE function
• Calc CEILING function
• Calc COS function
• Calc COUNT function