# How to Round a Formula Result in Excel (6 Easy Methods)

## How to Round a Formula Result in Excel: 6 Easy Ways

### 1. Applying ROUND Function

Steps:

• Select an empty cell.
• Enter the ROUND formula into the cell:

`=ROUND(D15,2)`

(D15 contains the number we want to round and 2 is the number of places we want to round to.)

• Press Enter.

The result is rounded to \$1,640.520.

Read More: How to Round a Formula with SUM in Excel

### 2. Using ROUNDUP Function

Steps:

• Select an empty cell.
• Enter the ROUNDUP formula into the cell.

`=ROUNDUP(D15,2)`

(D15 contains the number we want to round and 2 is the number of places we want to round to.)

• Press Enter.

The result is rounded up to \$1,640.520.

### 3. Use of ROUNDDOWN Function

Steps:

• Select an empty cell.
• Enter the ROUNDDOWN formula into the cell.

`=ROUNDDOWN(D15,2)`

(D15 contains the number we want to round and 2 is the number of places we want to round to.)

• Press Enter.

The result is rounded down to \$1,640.510.

### 4. Roundup a Formula Result Using Number Format

Steps:

• Select the cell with the number you want to round.
• In the Home tab, click on the Decrease Decimal command from the Number group. (You can also click the dialog box launcher in the corner of the drop-down.)

• When the Format Cells dialog box appears, find the Decimal Places box.
• Choose the number of places you want.
• Click OK.

The result is rounded to two decimal places.

Read More: How to Set Rounding Precision in Excel

### 5. Round a Formula Result to No Decimal Place

Steps:

• Select an empty cell.
• Enter the ROUND formula into the cell.

`=ROUND(D15,0)`

(D15 contains the number we want to round and 0 is the number of places we want to round to.)

• Press Enter.

The result is rounded to a whole number only: \$1,641.000.

Things You Should Know

You can also round a number to no decimal places (or fewer decimal places) using the Decrease Decimal command shown in Method 4. Itâ€™s in the Number group on the Home tab. Simply tap the Decrease Decimal command icon until you get your desired result.

### 6. Round a Formula Result to Nearest Multiple of 5

Steps:

• Select an empty cell.
• Enter the following ROUND formula into the cell.

`=ROUND(D15/5,0)*5`

(D15 contains the number we want to round, 5 is the multiple, and 0 is the number of decimal places.)

• Press Enter.

The result is rounded to \$1,640.000â€”the nearest multiple of 5.

Read More: Round to Nearest 5 or 9 in Excel

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF