How to Use Excel RANDBETWEEN Function (Examples + Video)

Excel RANDBETWEEN Function (Example + Video)

Excel RANDBETWEEN Function

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
  • 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:

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster