# Microsoft Excel – How to generate Random numbers?

Microsoft Excel provides `RAND` and `RANDBETWEEN` functions to generate Random numbers. Through this Article we are going to discuss about these two functions.

### Excel random number generator

#### The `RAND` function

This mathematical function is used to generate random numbers between 0 and 1. For example, 0.469059, 0.677718 etc,. Every time this function generates a new random number.

If you add this function, in your Excel sheet; whenever you open the Excel sheet, you will see the new random number displayed in the sheet.

No parameters are required to pass through this function. Here is an example;

`=RAND()`

#### The `RANDBETWEEN` function

Unlike `RAND` function, `RANDBETWEEN` function generates the random values between the given numbers. For example; if you want to generate random numbers between 1 and 100; you can use this function, pass the start and end numbers as arguments to generate a random number between the given numbers.

It looks like below;

`=RANDBETWEEN(1, 100)`

🙂 Sahida

Microsoft Excel – How to generate Random numbers?
Scroll to top