Exceljet

Quick, clean, and to the point

Excel RANDBETWEEN Function

Excel RANDBETWEEN function
Summary 
The Excel RANDBETWEEN function returns a random integer between given numbers. RANDBETWEEN recalculates when a worksheet is opened or changed.
Purpose 
Get a random integer between two values
Return value 
An integer
Syntax 
=RANDBETWEEN (bottom, top)
Arguments 
  • bottom - An integer representing the lower value of the range.
  • top - An integer representing the lower value of the range.
Usage notes 

Use the RANDBETWEEN function to get a random integer between bottom and top. For example, =RANDBETWEEN(1,50) might generate the number 28

RANDBETWEEN calculates a new value each time the worksheet is calculated. To stop random numbers from being updated, copy the cells that contain RANDBETWEEN to the clipboard, then use Paste Special > Values to convert to text.

To generate a set of random integers in multiple cells, select the cells, enter the RANDBETWEEN function, and press control + enter.

To get a random number that doesn't change when the worksheet is calculated, enter RANDBETWEEN in the formulas bar and then press F9 to convert the formula into its result.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.