Excel Function: RANDBETWEEN

The RANDBETWEEN function returns a random integer between the specified values (inclusive).

Usage:

=RANDBETWEEN(min, max)


Usage Example

To get random integers ranging from 111 to 222, enter:

=RANDBETWEEN(111,222)

excel function randbetween

To generate random decimal numbers, apply a division or use the RAND function.