Organizing data using various techniques is quite common in Microsoft Excel. Records are arranged in a tabular form here. You might need a dataset for random number entry in Excel that will be visible in decimals as well. This article will help you with four ways to enter a random number in excel with decimals. It is applicable for multiple cells in Excel and you can eventually modify it according to your requirements. All the methods have step-by-step instructions with a figurative description.
๐ Download Excel File
Download the Excel file below.
Learn to Introduce Random Number in Excel with Decimals with These 4 Suitable Approaches
The article is going to introduce four approaches in Excel to enter a random number in excel with decimals. The methods will help you understand the uses elaborately. The following discussion will cover the uses of the RAND, the RANDBETWEEN, and the RANDARRAY functions to enter a random number in excel with decimals. Therefore, users will get a walkthrough of these solutions. A dataset will be modified in the following methods below to help you understand.
1. Using RAND Function from 0 to Any Limit
The RAND function is widely used to enter any random numbers in Excel. The simplest form is to multiply a number with the function itself if you need numbers varying from 0 to that number. Following is an example where Excel creates a dataset for you varying from 0 to 75.
โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ
- Initially, select cell B6.
- Next, enter the following formula.
- Here, hit Enter.
- Then, dragging the Fill Handle icon, copy the formula till cell D9.
- Finally, you get a random number dataset with decimals in Excel.
๐ Read More: Generating Random Number Between Two Numbers in Excel
2. Applying RAND Function for Any Specific Limit
Like the first method, this method is also based on the RAND function. Following is an example where Excel creates a dataset for you varying from 50 to 75, with a formula set by upper and lower limit specifications.
โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ
- To begin with, select cell B6.
- Now, enter the following formula.
- Then, hit Enter.
- After that, dragging the Fill Handle icon, copy the formula till cell D9.
- Therefore, you will be able to get a random number dataset in Excel with decimals.
๐ Read More: 6 Ways to Generate Random 10-Digit Number in Excel
3. Combining RANDBETWEEN and RAND Functions
Now you can directly use a formula as well with the help of the RANDBETWEEN function and the RAND function. Following is an example where Excel creates a dataset for you varying from 35 to 85, with a formula set by upper and lower limit specifications.
โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ
- Firstly, select cell B6.
- Secondly, enter the following formula.
- Thirdly, hit Enter.
- Fourthly, dragging the Fill Handle icon, copy the formula till cell D9.
- Fifthly and finally, you can get the dataset with decimals in Excel.
๐จ Formula Breakdown
RANDBETWEEN(35,85-1)+RAND()
๐ย Here, RANDBETWEEN brings the random numbers from 35 to 85.
๐ย Also, RAND adds random numbers from 0 to 1.ย
Finally, we get 70.37.
๐ Read More: 5 Ways to Generate Random Number Between 0 and 1 in Excel
4. Utilizing RANDARRAY Function
In Excel from Microsoft 365, you can use the RANDARRAY function to automatically generate an entire random number dataset in Excel with decimals.
โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ
- In the beginning, select cell B6.
- Now, enter the following formula.
- Then, hit Enter.
- Moreover, you get a random number dataset to you with decimals automatically.ย ย
๐ Read More: 7 Ways to Create Random 5 Digit Number Generator in Excel
๐ Important Notes
๐๏ธย Before and after using the Fill Handle icon, your random numbers will change for the source formula cell.
๐๏ธย The last method is only applicable to Microsoft 365 users.
๐ Takeaways from This Article
The article lets the readers understand the variety of options available to enter a random number in excel with decimals.
๐ย Primarily, you can use the RAND function for 0 to any number you want.
๐ย Also, you can apply the RAND function for a specific range. It helps you to get random numbers with decimals.
๐ย Here, you can combine the RANDBETWEEN and RAND functions.
๐ย Finally, you can utilize the RANDARRAY function in Microsoft 365 as well.ย
Conclusion
To enter a random number in excel with decimals, four methods are available. You can use the RAND, the RANDBETWEEN, and the RANDARRAY functions to enter a random number in excel with decimals. In case of further queries, readers are requested to leave a comment for the author. The author will try their best to come up with a suitable solution. Follow ExcelDen to get more access to solutions regarding your Excel problems.
Related Articles
- 8 Ways to Make Random 4 Digit Number Generator in Excel
- 4 Steps to Auto Generate Invoice Number in Excel
- 8 Easy Tricks to Generate Random Data in Excel