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

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

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