RANDBETWEEN function

The RANDBETWEEN function returns a random integer within the range between two specified numbers. Each update returns a new random integer.

Format

• RANDBETWEEN(bottom, top)

Arguments:

• bottom — Required. The smallest integer returned by the RANDBETWEEN function.
• top — Required. The largest integer returned by the RANDBETWEEN function.

Examples

Formula	Description	Result
RANDBETWEEN(1,100)	Random number between 1 and 100 (changes)	changes
RANDBETWEEN(-1,1)	Random number between -1 and 1 (changes)	changes

Go To

• Standard functions