RANDBETWEEN function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Returns a random number between the numbers you specify

Syntax

RANDBETWEEN(bottom, top) The RANDBETWEEN function syntax has the following arguments:
• Bottom Required. The smallest integer RANDBETWEEN will return.
• Top Required. The largest integer RANDBETWEEN will return.

Example

=RANDBETWEEN(1,100)
=RANDBETWEEN(-1,1)

Microsoft Support Page

https://support.microsoft.com/en-us/office/randbetween-function-4cc7f0d1-87dc-4eb7-987f-a469ab381685

Back to Functions