Скачать или смотреть How To Enter, Generate (Get) A Random Number Between 1 And 100 In Excel Explained

In this video we discuss how to input or enter a random number between 1 and 100 in a cell in excel using the RANDBETWEEN function. We go through a detailed example step by step

Transcript/notes
Let’s say that you want excel to put a random whole number between 1 and 100, for example in cell A2. To do this, we use the RANDBETWEEN built in excel function. Start by left clicking on cell A2, so it is highlighted. Next, type in an equals sign, then type in ran, and in the drop down box, left double click on the randbetween option.

Next, you type in the lower limit number you want, in this case 1, then type in a comma. From here, type in the upper limit number you want, in this case 100. Then type in a closed parenthesis and hit the enter key, and we have a random whole number between 1 and 100.

One important thing to take note of. I am going to highlight the cell and use the fill handle to drag down and fill in some more rows in the column, as you see here. If I put any other entries in the worksheet, as you see I’m doing here, the random numbers in the column keep re-calculating, this is how the randbetween function works.

To permanently enter these random numbers into the worksheet we are going to left click, hold and drag to highlight all of the cells with the random numbers. From here, hit control C, which is the shortcut for copy. Then right click anywhere in the highlighted cells and a pop box appears. Next, under paste options, left click on the paste 123 icon, which is paste values.
Now, if I left click on any of the random number cells, as you see here, the randbetween function is gone and the cell now contains a permanent random number.

Chapters/Timestamps
0:00 Intro
0:10 How to enter a random number between 1 and 100 in excel
1:03 How to make random numbers permanent