Generate Random Numbers with Decimals in Microsoft Excel

Generate Random Numbers with Decimals in Microsoft Excel

HomeOther ContentGenerate Random Numbers with Decimals in Microsoft Excel
ChannelPublish DateThumbnail & View CountActions
Channel Avatar TeachExcel2009-01-21 23:37:34 Thumbnail
100,429 Views
http://www.TeachMsOffice.com
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 http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

Please take the opportunity to connect and share this video with your friends and family if you find it useful.