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.
The output from each of these functions is shown below: