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?

Leave a Reply

Your email address will not be published.

Scroll to top