In this article, we will learn the random number generator in Microsoft Excel. To generate the random number, we will use the “RAND” and “RANDBETWEEN” function.
Rand function is used to returns the random number greater than or equal to 0 and less than 1, and also it recalculates all time when we do any activity in the sheet.
Syntax of “RAND” function: =RAND()
Note:- Random numbers change every time a cell on the sheet is calculated.
RANDBETWEEN:- This function is used to extract a random integer number between the two specified (bottom & top) numbers. A new random integer number gets generated every time the worksheet is calculated.
Syntax of RANDBETWEEN:- =RANDBETWEEN(bottom,top)
This is all about how we can produce the random numbers by using the formula Rand and Randbetween in Microsoft Excel.
Let’s take an example on array of random numbers without duplicates
In case you want to generate random number in Excel within a specified upper & lower limit without VBA, then you will have to generate Random numbers with Excel Randbetween function. In this article, let’s discuss how to apply this function.
Question: I want to create a list of random numbers between 1 to 10 in a column without repetition.
Note: This is an array formula. Use CTRL + SHIFT + ENTER keys together
In this way we can use RAND & RANDBETWEEN functions in excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.