Formula Errors

How to Sum, Multiply, and Round Values in an Excel Formula

Camila Milosovich Sep 30, 2026 868 views

Question details

The user needs a single Excel formula to add two cells together, multiply their sum by 0.1, and round the final result to exactly two decimal places.

How to Sum, Multiply, and Round Values in a Single Excel Formula

Product: Excel
Device & OS: not provided
Scenario: Calculating a specific mathematical operation that combines addition, multiplication, and number formatting (rounding) into a single spreadsheet cell.
Observed behavior: The user wants to find the correct nested syntax combining basic addition operators with the ROUND function to achieve the desired calculation order and format.

Before you start

Identify the specific cell references you want to calculate (such as D23 and E23) and double-check that they contain valid numerical data before applying the nested formula.

Solution 1Recommended

Use a Nested Formula with Addition, Multiplication, and ROUND

Combine basic arithmetic operators within the ROUND function to calculate and format the result in one seamless step.

Excel allows you to nest mathematical operations inside functions. By placing the addition and multiplication inside the ROUND function, Excel evaluates the math first and then applies the rounding to the final number.

Select the target cell

Click on the empty cell where you want the final calculated result to be displayed.

Enter the nested formula

Type the formula exactly as follows: =ROUND((D23+E23)*0.1, 2) into the formula bar. Adjust the cell references (D23, E23) and the multiplier (0.1) if your actual data is located elsewhere.

Calculate the result

Press the Enter key. Excel will first add D23 and E23 together, multiply that sum by 0.1, and then mathematically round the output to exactly two decimal places.

Understanding the Syntax: The parentheses around (D23+E23) are crucial. They ensure the addition is performed before the multiplication, strictly following standard mathematical order of operations (PEMDAS).

Master Spreadsheet Formulas with WPS Office

Easily Calculate and Manage Complex Formulas with WPS Spreadsheet

WPS Office provides a highly compatible and intuitive spreadsheet application that fully supports standard Excel formulas, including ROUND, SUM, and nested mathematical operations. You can seamlessly open, edit, and calculate your workbooks for free with a familiar interface.

1. Download and Install WPS Office: Visit the official WPS website to download the free office suite and install it on your computer.
2. Open your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook containing your data.
3. Apply the Formula: Select your target cell, input the formula =ROUND((D23+E23)*0.1, 2), and press Enter to instantly calculate your combined and rounded results.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formatsComprehensive support for standard mathematical functions and nested formulasBuilt-in formula auditing tools to easily spot and fix syntax errorsLightweight, fast, and completely free to use across Windows, Mac, and mobile

microsoft office alternative - wps office

Frequently Asked Questions

Can I use the SUM function instead of the plus sign for addition?

Yes, you can substitute the addition operators with the SUM function. For example, instead of (D23+E23), you can write SUM(D23:E23). The updated formula would be =ROUND(SUM(D23:E23)*0.1, 2).

What happens if I change the '2' at the end of the ROUND formula to a '0'?

The second argument in the ROUND function specifies the number of decimal places. Changing the '2' to a '0' will round the final calculated result to the nearest whole number, removing all decimal digits.

Why am I getting a #VALUE! error when using this nested formula?

A #VALUE! error typically occurs if one of the referenced cells (like D23 or E23) contains text, a space, or special characters instead of a number. Ensure both source cells contain valid numerical data.

Can I force Excel to always round up or always round down?

Yes. If you need a specific rounding direction regardless of the mathematical rule, replace ROUND with ROUNDUP to always round up, or use the ROUNDDOWN function to always round toward zero.

Excel & Data Problems