how to generate random numbers in excel

preview_player
Показать описание
#Shorts
How to Create Random Numbers in Excel
Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.

The Microsoft Excel RANDBETWEEN function returns a random number that is between a bottom and top range. The RANDBETWEEN function returns a new random number each time your spreadsheet recalculates.

If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.
Рекомендации по теме
Комментарии
Автор

If you want to generate random numbers use this formula. Subscribe to my channel for longer videos on how to use excel.

opentrainingcamp