The RANDBETWEEN function takes two arguments: bottom and top. Bottom represents the lower bound for a random number, and top represents the upper bound. RANDBETWEEN includes both top and bottom values in the range of integers that may be returned.
Examples
Below are basic examples of RANDBETWEEN formulas:
Multiple results
To generate multiple random numbers in multiple cells, select the target cells, enter the RANDBETWEEN function, and press control + enter to enter the same formula in all cells at once.
Static results
RANDBETWEEN returns a new random value each time the worksheet is recalculated, including changes made to unrelated cells in the same workbook. To stop random numbers from changing, copy the cells that contain RANDBETWEEN to the clipboard, then use Paste Special > Values to convert to text. To get a single random number that doesn’t change, enter RANDBETWEEN in the formula bar, press F9 to convert the formula to a static result, and press Enter to enter the value in the cell. Note: in Excel 365, the RANDARRAY function is a more flexible alternative. RANDARRAY can generate random decimal numbers and random integers, and can also return more than one random value at the same time.
Notes
RANDBETWEEN recalculates whenever a worksheet is opened or changed. RANDBETWEEN returns integers. Use the RAND function to return random decimal values.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
