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