Randbetween Function – Generate Random integers

Randbetween Function

The Excel RANDBETWEEN function returns a random integer (number) between given numbers.

When using the RANDBETWEEN function, please note that it recalculates when a worksheet is opened or changed. To lock in the numbers, you have can use the RANDBETWEEN function and copy/paste special the random values. This will convert the values to text.

Syntax:

=randbetween(bottom,top)

This function is self-explanatory.

You can use the fill handle to generate a list of random integers.

Was this article helpful?

Related Articles

Leave a Reply