Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Generate Random Numbers with Decimals in Microsoft Excel


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.

This is a very useful trick when running simulations in excel.
   Topics Covered
Generate Random Numbers which are Fractions and Decimals in Excel
Generate Numbers with Decimals Between two limits - an upper and a lower limit
RAND() Function
   Difficulty:         Intermediate
   Video:               Yes



Got a Question? Ask it Here in the Forum.