When to use Excel RANDBETWEEN Function

RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between a top and bottom range specified by the user.

What it Returns

It returns a number between the top and bottom range specified by the user.


=RANDBETWEEN(bottom, top)

Input Arguments

bottom – The smallest integer RANDBETWEEN will return. top – The largest integer RANDBETWEEN will return.

Additional Notes

RANDBETWEEN is a volatile function and should be used with caution It recalculates whenever the excel workbook is open or whenever a calculation is triggered in the worksheet. This means that the value of RAND keeps on changing. Since volatile functions re-calculates so often, it adds to the processing time and slow down your workbook. It can be forced to recalculate by pressing the F9 key. This recalculates the entire workbook calculations If you want to use RANDBETWEEN to generate a random number but don’t want the numbers to change every time the cell is calculated, you can enter =RANDBETWEEN(bottom, top) in the formula bar, and then press F9 to change the formula to a random number.

Excel RANDBETWEEN Function – Live Example

Excel RANDBETWEEN Function – Video Tutorial

Related Excel Functions:

Excel INT Function. Excel MOD Function. Excel RAND Function. Excel ROUND Function. Excel RANK Function. Excel LARGE Function. Excel MAX Function. Excel MIN Function. Excel SMALL Function.

Generate Unique Random Numbers in Excel. Random Group Generator Template [FREE Download]. How to Generate Random Numbers in Excel.