RANDBETWEEN Function

Description

The RANDBETWEEN function returns a random integer number between the numbers you specify. A new random integer number is returned every time the Worksheet is calculated.

Syntax

RANDBETWEEN (bottom, top)

Arguments

Argument	Description	Required/Optional
Bottom	The smallest integer RANDBETWEEN will return.	Required
Top	The largest integer RANDBETWEEN will return.	Required

Notes

If the specified bottom argument is greater than the supplied top argument, RANDBETWEEN returns #NUM! error.
If either of the supplied arguments is not recognized as a numeric value, RANDBETWEEN returns #VALUE! Error.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_math_trigonometric_functions.htm