Answer (1 of 7): Use the RANDARRAY() function. The result is then always between 20 and 50. https://www.dropbox.com/s/ec431fu0h0fhb5i/RandomNumbers.xlsx?dl=0. Use the RAND formula and do some maths: The interval is 30 (=50-20). Not the answer you're looking for? Then multiply it by 65 minus 18 (which symbolize the maximum and minimum numbers). If we remove the ROUND function from the formula, we will get decimal numbers instead of integers. 1. Since we want random numbers between 1 and 12, 12-1=11. Ribbon (3) if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { } Select a Random Decimal Value Between 0 and 1 If you want to generate a random decimal value between 0 and 1, simply used the Excel Rand function by entering the following formula into any cell of your worksheet: =RAND () This function will generate a different random decimal, between 0 and 1 every time your worksheet re-calculates. To use the Function in Excel worksheet,simply type =RAND() I hope this all helps you excel at the office. But, using the following RAND formula in Excel, you can use RAND ()to return random numbers between 0 and 100. How To Use Workbook Functions To Generate Random Numbers.