Excel Forum



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.