Generate Random Numbers with Decimals in Microsoft Excel
Вставка
- Опубліковано 26 сер 2024
- www.TeachMsOffi...
This tutorial shows you how to generate random numbers which have decimals in excel. This means the numbers will not just be integers; they will be decimals or fractions between two limits which you set. This is similar to the RANDBETWEEN() function except that that function only returns integers. Here, the RAND() function is used to create the decimal numbers in excel.
To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website www.TeachExcel.com You can also visit the forum there if you have any questions.
Have a great day!