#Random data generator excel how to#

If the bottom is greater than the top, the RANDBETWEEN function will return #NUM! Error.Like the RAND() function, we can also type the RANDBETWEEN function in the formula bar, pressing F9 to convert the result into value, and then press the “Enter” key. You can prefer the below-given screenshot.Īs values will recalculate, we can only use “ Alt+Ctrl+V” to open the “Paste Special” dialog box to paste as values.įollow the steps given below in the screenshot.

To generate random numbers in Excel for the students between 0 and 100, we will use the ‘RANDBETWEEN’ function.įirst, we must select the data, type the formula, =RANDBETWEEN(0,100), and press the “Ctrl + Enter” keys. Top: An integer representing the lower value of the range. The formula of the RANDBETWEEN Function is:īottom: An integer representing the lower value of the range. Like the RAND() function, this function also recalculates when a workbook is changed or opened ( volatile function). Value from a Different Range other than 0 and 1 using RAND()Īs the RAND function returns a random decimal number between 0 and 1 only, if we want the value from a different range, then we can use the following function:įor example, if we have 7 as “a” and 10 as “b,” then the formula would be “ =RAND()*(10-7)+7.” RANDBETWEEN() FunctionĪs the function’s name indicates, this function returns a random integer between given integers. First, type =RAND() in the formula bar, press F9, and press the “Enter” key.Īfter pressing F9, we get the value only.If we want the value the very first time, not the function, then the steps are: There is one more way to get the value, only not the function as a result, but that is only for one cell. We can see that the value in the formula bar is the value itself, not the RAND() function. Choose “Values” from the options and click on “OK.”.Without changing the selection, press the Alt+Ctrl+V keys to open the “Paste Special” dialog box.Press the “ Ctrl+C” keys to copy the values.We need to make the selection of the values.For this, we need to paste the values of the RAND() function using Paste Special so that it would no longer be a result of the “RAND ()” function.

#Random data generator excel how to#

How to Stop Recalculation of Random Numbers in Excel?Īs the RAND function recalculates, if any change in the sheet is made, we must copy and then paste the formulas as values if we do not want values to be changed every time.

First, select the required range, type =” RAND(), “and press the “Ctrl+Enter” to give us the values.

If we want to generate random numbers in Excel for more than one cell, then we need: How to Generate Random Numbers in Excel for more than One Cell?