Random Numbers in Excel
To generate a random number in Excel, use the RAND()
function, which returns a random number between 0 and 1. It will return a different random number each time the cell is recalculated (e.g. if you re-calculate by pressing F9) or the next time you open the workbook.
Random Numbers in a Specified Range
To get a random integer (i.e. whole number) in a particular interval, use the RANDBETWEEN()
function. This has two parameters which are the lowest and highest values you want to get a random number between. For example, =RANDBETWEEN(200,300)
will return a random integer between 200 and 300. Again, you’ll get a new random number each time you refresh (you can Copy and Paste Values into the same cells if you want to keep the random numbers you’ve generated).
If you need a random number in an interval which isn’t rounded to the nearest whole number, you can use the output from the RAND()
function and a bit of simple maths to get this. For example, =200 + RAND()*(300-200)
will give you a random number between 200 and 300 which isn’t rounded.
Example
The output from each of these functions is shown below: