![]() To avoid getting the random numbers recalculate, again and again, convert the result of the formula to values. Note that RANDBETWEEN is a volatile function and recalculates every time there is a change in the worksheet. If you’re OK with duplicates, RANDBETWEEN is the easiest way to generate random numbers in Excel. While RANDBETWEEN makes it easy to get integers between the specified numbers, there is a high chance of repetition in the result.įor example, when I use the RANDBETWEEN function to get 10 random numbers and use the formula =RANDBETWEEN(1,10), it gives me a couple of duplicates. This will instantly give me 10 random numbers in the selected cells. In the active cell, enter =RANDBETWEEN(1,100). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |