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.

**approach**

**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.

**=RAND()*75**

- 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**

**approach**

**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.

**=RAND()*(75-50)+50**

- 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**

**approach**

**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.

**=RANDBETWEEN(35,85-1)+RAND()**

- 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**

**approach**

**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.

**=RANDARRAY(4,3,40,90,FALSE)**

- 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**