The RANDBETWEEN function returns a random integer number between the numbers specified. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.
- All Excel versions
An integer representing the smallest value the function will return.
An integer representing the largest value the function will return.
Note that we are using named ranges in formulas to make them easier to read. This is not required.
- The RANDBETWEEN function is a volatile function that returns a new random integer after every workbook calculation. Press F9 to update the value.
- Use the RAND function to return a random real number between 0 and 1.
- To generate a set of random numbers, select the cells, enter the =RANDBETWEEN(bottom,top) formula and press Ctrl + Enter (⌃ + Return in Mac).
- Microsoft has announced that they're soon going to release the RANDARRAY function to Office 365 subscribers. This new dynamic array function allows creating an array of randomly generated numbers.