# How to Round to Nearest Whole Number in Excel (9 Methods)

Here’s a simple dataset that contains numbers in column B, which we’ll round in column C or D.

## Method 1 – Using the ROUND Function to Round to the Nearest Whole Number in Excel

Steps

• Select cell D5 and enter the following formula.
`=ROUND(B5,0)`

• Drag the Fill Handle button in the corner of cell D5 to cell D12.

## Method 2 – Applying EVEN and ODD Functions for Rounding to the Nearest Whole Number

Steps

• Select cell D5 and enter the following.
`=EVEN(B5)`

• Select cell D6 and enter the following formula.
`=ODD(B6)`
• Enter the EVEN or ODD function for the remaining cells depending on whether the whole portion is even or odd.

## Method 3 – Inserting the TRUNC Function to Round in Excel

TRUNC cuts off the decimal portion of a number.

Steps

• Select cell D5 and enter the following formula.
`=TRUNC(B5,0)`

• Drag the Fill Handle button in the corner of cell D5 to cell D12.

Read More: Round to Nearest 5 or 9 in Excel

## Method 4 – Rounding to the Nearest Whole Number Using the INT Function

Steps

• Select cell D5 and enter the following formula:
`=INT(B5)`
• The INT Function will round down the number to its nearest integer.

• Drag the Fill Handle button in the corner of cell D5 to cell D12.

## Method 5 – Applying the MROUND Function for Rounding in Excel

With the MROUND function, we can round values to the multipliers.

Steps

• Select cell D5 and enter the following:
`=MROUND(B5,1)`
• The Multiple here is chosen as 1, so the number will be rounded to a multiple of 1. The numbers will round closer to the nearest integer value in every case.

• Drag the Fill Handle icon in the corner of cell D5 to cell D12.

Note:

The Number argument and the Multiple argument must have the same sign.

## Method 6 – Inserting the FLOOR Function to Round to the Nearest Whole Number

Steps

• Select cell D5 and enter the following.
`=FLOOR(B5,1)`
• The Multiple here is chosen as 1, so the number will be rounded down to a multiple of 1 in every case. The numbers will be rounded closer to the nearest integer value in every case.

• Drag the Fill Handle button in the corner of cell D5 to cell D12.

Note:

• If any of the arguments in the FLOOR function are not numeric, the FLOOR function will return the #VALUE! error.
• If the number value is negative, the formula rounds up. If the number is positive, the formula rounds down.
• If the Significance number has fractions or decimal parts, the rounding will not result in an integer number.
• You can use the FLOOR.MATH function to automatically round the number down to an integer.

Read More: Round Down to Nearest 10 in Excel

## Method 7 – Using the CEILING Function to Round to the Nearest Whole Number in Excel

The CEILING function will round up the numbers.

Steps

• Select cell D5 and enter the following:
`=CEILING(B5,1)`
• The significance here is chosen as 1, so the original number will be rounded down to a multiple of 1 in every case.

• AutoFill the column.

Note:

You can also use the CEILING.MATH function to round the numbers directly.

Read More: How to Round to Nearest 100 in Excel

## Method 8 – Applying the Decrease Decimal Command to Round in Excel

Steps

• Copy the data from the range of cells B5:B12 to the range of cells C5:C12.
• Select the new cells.
• From the ribbon menu, click twice on the Decrease Decimal command from the Number group in the Home tab.

• The numbers in the range of cells C5:C12 are now free from the fractional part.
• Use the command again if needed.

## Method 9 – Rounding to the Nearest Whole Number Through the Built-in Number Format

Steps

• Copy the cells from the range of cells B5:B12 and paste them to the range of cells C5:C12.

• Select the range of cells D5:D12, right-click, and select Format Cells.

• A new window will open. Click on Number from the Category section.
• Set the decimal places to 0.
• Click OK.

• Here are the results.

Read More: How to Round to Nearest 1000 in Excel

<< Go Back to Rounding in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF