Skip to Content

RANDBETWEEN

Returns a random integer between the numbers you specify

Syntax

RANDBETWEEN(bottom, top)

Parameters

  • bottom: Required. The smallest integer RANDBETWEEN will return
  • top: Required. The largest integer RANDBETWEEN will return

Example

=RANDBETWEEN(1, 100)
Returns: NumberSince: Excel 2003