Generate Random number using RAND Function in Excel

RAND function in Excel generates a random real number between 0 and 1.  With the Help of Excel RAND Function we can also generate a random real number between any two values say a and b using the formula

RAND( ) * (b – a) + a

Where a and b are the values between which your random number will be

Syntax of RAND Function in Excel

1)  RAND()

2) RAND( ) * (b – a) + a

Syntax 1) for generating random number between 0  and 1

Syntax 2) for generating random number between a and b

 

Example of RAND Function in Excel

Formula

RAND Function in Excel 1

  • Row number 2 generates random number between 0 and 1
  • Row number 3 generates random number between 0 and 10
  • Row number 4 generates random number between 0 and 100
  • Row number 5 generates random number between 2 and 20

So the result will be

Result

RAND Function in Excel 2

NOTE:  Random number changes every time when you save or refresh

 

Example: Generate 10 Random Number between 0 and 1

Now as a part of exercise lets generate 10 random number between 0 and 1

Step 1 : Select cell A2  and type =RAND() and press Enter

RAND Function in Excel 3

Step 2 :  To generate a list of random numbers click and drag it till cell A11

RAND Function in Excel 4

Step 3:  Random number changes every time when you save or refresh. So select the generated random number, copy it and paste values as shown below so that it will not change when you refresh or save.

RAND Function in Excel 5

 

 

Example: Generate 10 Random Number between 35 and 135 with Decimals

To generate random number with decimals use the formula in Cell A2

=RAND( ) * (b – a) + a .

Drag it till A11  , the output will be like

RAND Function in Excel 6

 

Example: Generate 10 Random Number between 35 and 135 without Decimals

To generate random number with decimals use the formula  in the cell A2

=RANDBETWEEN(a,b)

Drag it till A11, the output will be like

RAND Function in Excel 7

RANDBETWEEN Function is explained detail in the next chapter

previous-small RAND Function in Excel                                                                                                                next_small RAND Function in Excel