4 Ways to Introduce Random Number in Excel with Decimals

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.

Dataset to enter any random number with decimals in Excel


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.

Using RAND function to enter any random number 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.

Applying RAND function for any limit to enter any random number with decimals in excel

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

Combining RANDBETWEEN and RAND functions to enter any random number 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.  

Utilizing RANDARRAY function for random number with decimals in excel

📕 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

(Visited 51 times, 1 visits today)
Farihat

Farihat

An Excel enthusiast who wants to share and loves to solve Excel problems. I try to explore available options to guide readers to the maximum ways how they can solve. The world is limitless, and so are the problems in it. Let's help each other to grow. I would love to hear feedback and queries from readers. You can visit my LinkedIn for further information.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo