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

**Table of Contents**hide

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

- Now, use
**Fill Handle**to**AutoFill**the rests.

**Read More: How to Round Excel Data to Make Summations Correct**

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

- Hit
**ENTER**.

**AutoFill**the remaining cells.

**Read More: ****How to Remove Decimals in Excel with Rounding**

**Similar Readings**

**How to Add ROUND Formula to Multiple Cells in Excel****Rounding to Nearest Dollar in Excel****How to Stop Excel from Rounding Large Numbers**

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

- Finally,
**AutoFill**the rests.

**Read More: ****How to Roundup a Formula Result 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

- Press
**ENTER**.

**AutoFill**to finish the process.

**Read More: ****Round off Formula in Excel Invoice**

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

**How to Set Decimal Places in Excel with Formula****How to Round to Nearest Whole Number in Excel****How to Round Down to Nearest Whole Number in Excel****How to Round Numbers to the Nearest Multiple of 5 in Excel****Round Down to Nearest 10 in Excel****How to Round to Nearest 100 in Excel****How to Round Numbers to Nearest 10000 in Excel****How to Round a Formula with SUM in Excel****How to Round up Decimals in Excel****How to Round Up to 2 Decimal Places in Excel****How to Get 2 Decimal Places Without Rounding in Excel****How to Round Percentages in Excel****How to Set Rounding Precision in Excel****How to Round Time in Excel****How to Round Time to Nearest Minute in Excel****Round Time to Nearest 5 Minutes in Excel****How to Round Time to Nearest 15 Minutes in Excel****Rounding Time in Excel to Nearest Hour****Rounding Time to Nearest Quarter Hour in Excel****How to Round to Nearest 10 Cents in Excel****How to Round Off to Nearest 50 Cents in Excel****How to Stop Rounding in Excel****How to Remove Decimals without Rounding in Excel****How to Stop Excel from Rounding Up Decimals****How to Round a Multiplication Formula in Excel****How to Round Numbers in Excel Without Formula**