How to Round Down to Nearest Whole Number in Excel (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

We try to make our dataset both beautiful and simple at the same time.  In order to decorate our data, sometimes we face the necessity to round down to the nearest whole number in Excel. Here, I will try to discuss 4 smooth approaches to do that.

For more simplification, I am going to use a Dataset with the columns Batsman, Country, Test Average, and Round Down Average.

 Excel Round Down to Nearest Whole Number


How to Round Down to Nearest Whole Number in Excel: 4 Smooth Approaches

1. Applying ROUNDDOWN Function

There is a function named ROUNDDOWN Function. We can easily round down to the nearest whole number in Excel with it.

Steps:

  • Select a cell (e. D5).
  • Input the following formula:
=ROUNDDOWN(D5,0)

Where,

D5 = The number we want to round down

0 = The number of digits to which we want in the decimal positions

  • Press ENTER.

Excel Round Down to Nearest Whole Number

  • Now, use Fill Handle to AutoFill the rests.

Read More: How to Round to Nearest Whole Number in Excel


2. Using FLOOR Function to Round Down to Nearest Whole Number

The FLOOR function is an amazing function to perform it perfectly.

Steps:

  • Choose a cell (e. D5).
  • Now, input the following formula:
=FLOOR(D5,1)

Where,

D5 = The number we want to round down

1 = The multiple to which we want to round the number

Excel Round Down to Nearest Whole Number

  • Hit ENTER.

  • AutoFill the remaining cells.

Excel Round Down to Nearest Whole Number

Read More: Round to Nearest 5 or 9 in Excel


3. Round Down to Nearest Whole Number Utilizing TRUNC Function

We can also use the TRUNC Function to perform our purpose.

Steps:

  • Pick a cell (e. D5).
  • Write the following formula in that cell:
=TRUNC(D5,0)

Where,

D5 = The number we want to round down

0 = The number of digits to which we want in the decimal positions

  • Next, press ENTER.

Excel Round Down to Nearest Whole Number

  • Finally, AutoFill the rests.

Read More: How to Round Numbers to the Nearest Multiple of 5 in Excel


4. Using INT Function

The INT Function can also round down to the nearest whole number.

Steps:

  • First of all, select a cell. I selected cell D5.
  • Next, input the following formula in the D5 cell:
=INT(D5)

Where,

D5 = The number that we want to round down

Excel Round Down to Nearest Whole Number

  • Press ENTER.

  • AutoFill to finish the process.

Excel Round Down to Nearest Whole Number

Read More: Excel VBA: Round to Nearest 5


Practice Section

You can practice here for more expertise.


Download Practice Workbook


Conclusion

In this article, I mentioned 4 Smooth approaches to round down to the nearest whole number in Excel. Hopefully, it will be helpful for Excel users. For any more questions, comment below.


Related Articles


<< Go Back to Round to Nearest Whole Number | Rounding in Excel | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly 2 years. Currently serving as an Excel and VBA Content Developer, Arif has authored over 120 articles. His expertise lies in Microsoft Office Suite, and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and ongoing enthusiasm for expanding his knowledge in data analysis.

Designation

Excel &... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo