Excel RANDBETWEEN Function (Example + Video)
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.
Syntax
=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
- 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.
- 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.
You May Also Like the Following Excel Tutorials:
