How to Generate Random Numbers in Excel


In this tutorial, you are going to learn how to use the Excel random number generator.

Step # 1 – Generate a random number from 0 to 1

First, open a new spreadsheet. Click in cell A1 (or wherever you want to insert a random number). Type “=RAND( )” in the cell. This will generate a random number from 0 to 1.

Generating a standard random number

Step # 2 – Generate a random number from 0 to n

Click another cell (here the A2 cell). If you want to generate a number from 0 to any number you want, type “=RAND( )*”. Then a number you want to generate up to, here we are entering 10. This will generate any number from 0 to 10.

Specifying a range for the random number

Step # 2 – Generate a random number from a given range

Click into another cell (here A3). If you want to generate a number in a given range, type “=RAND( )*([top end number]-[low end number])+[low end number]”. The example we are using here is “=RAND( )*(50-5)+5”. This will generate any number from 5 to 50. That’s it, you now know how to use the Excel random number generator.

Another range being specified