# How to round to the nearest whole number in Excel

You can watch a video tutorial here.

When working with numbers, many times you need to round a decimal value to the nearest whole number. In Excel, there are several ways of doing so.

## Option 1 – Use the Decrease decimal button

### Step 1 – Decrease the decimals

- Select the cells
- Go to
**Home > Number** - Keep clicking the
**Decrease Decimal button**until the number becomes a whole number

## Step 2 – Check the result

- This changes only the display of the number and does not change the number itself

## Option 2 – Format the cell

### Step 1 – Open the **Format Cells** window

- Select the cells
- Go to
**Home > Number**and click on the arrow to expand the menu

OR

Right-click and select **Format Cells ** from the context menu

OR

Go to **Home > Cells > Format > Format Cells**

- Go to the
**Number**option on the**Number**tab - Change the
**Decimal places**to zero (0)

## Step 2 – Check the result

- This changes only the display of the number and does not change the number itself

## Option 3 – Use any of the ROUND functions

### Step 1 – Use the ROUND() function with zero decimal places

- Select the destination cell
- Type the formula:

=round(<cell reference of the number to be rounded>,0)

- Copy the formula to the rest of the cells
- The numbers are rounded to the nearest whole number (either up or down) depending on the value of the numbers after the decimal point

### Step 2 – Use the ROUNDUP() function with zero decimal places

- Select the destination cell
- Type the formula:

=roundup(<cell reference of the number to be rounded>,0)

- Copy the formula to the rest of the cells
- The numbers are rounded up to the nearest whole number

### Step 3 – Use the ROUNDDOWN() function with zero decimal places

- Select the destination cell
- Type the formula:

=rounddown(<cell reference of the number to be rounded>,0)

- Copy the formula to the rest of the cells
- The numbers are rounded down to the nearest whole number

### Step 4 – Use the MROUND() function with a multiple of 1

- Select the destination cell
- Type the formula:

=mround(<cell reference of the number to be rounded>,1)

- Copy the formula to the rest of the cells
- The numbers are rounded down to the nearest whole number

### Step 5 – Check the result

- The ROUND functions change the number itself and not just the display