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
welcome to shbcf.ru