How to Generate Random Numbers in Excel

Generating random numbers in excel is very easy..

There are two ways to achieve this:

1. Using the RAND() function, and
2. Using the RANDBETWEEN() function

The first is the easiest, you just have to input the formula on
your desired cell like this:
     
     =RAND()

and it will generate a random number between 0 and 1.

The latter is also easy but takes two (2) parameters,
the lower and upper boundaries.

To use the second function we use:

    =RANDBETWEEN(20, 50)

This will generate a random number between 20 and 50 as the given parameters.

To achieve, for example a number like 2.5, we just make boundaries in tens like 20 and 50 then divide the answer to 10.

    =RANDBETWEEN(20, 50)/10

Here a sample one:

Thanks guys and enjoy...