Function Problems

How to Add, Increase by a Percentage, and Divide in Excel Formula

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs to create a single, reusable formula that can add two values together, increase their sum by a specified percentage, and then divide the resulting total by a specific number.

Product: Excel
Device & OS: not provided
Scenario: Calculating complex financial data or adjusted totals where values must be sequentially summed, scaled by a percentage rate, and divided across multiple rows.
Observed behavior: The user requires the correct syntax to combine the SUM function with standard arithmetic operators (+, *, /) in one step without calculating intermediate values in separate cells.

Before you start

Ensure your data is organized into dedicated columns for the initial values, the percentage rate, and the divisor, and verify that the percentage column is properly formatted as a percentage (e.g., 5%) rather than a standard number.

Solution 1Recommended

Use a Combined Arithmetic Formula with the SUM Function

By nesting the SUM function within a larger arithmetic expression, you can perform addition, percentage multiplication, and division simultaneously in one cell.

This formula uses the mathematical order of operations. It first calculates the sum of the two values, then multiplies it by 1 plus the percentage to apply the increase, and finally divides the result by your chosen divisor.

Organize your data in columns

Enter your first two values into cells A2 and B2. Enter your percentage increase (e.g., 10%) into cell C2, and enter the number you want to divide by into cell D2.

Input the combined formula

Click on cell E2 (or your target output cell) and type the following formula: =SUM(A2:B2)*(1+C2)/D2.

Apply the formula to other rows

Press Enter to display the calculated result. To reuse this formula for additional data, click cell E2, hover over the small square at the bottom-right corner until your cursor becomes a cross, and drag the fill handle downward.

Formatting the Percentage: The expression (1+C2) assumes C2 is formatted as a percentage or a decimal. If C2 contains a whole number like '10' meant to represent 10%, you must change the formula to (1+(C2/100)) to prevent calculation errors.

Efficient Spreadsheet Calculations

Use WPS Spreadsheet for Complex Formulas

WPS Spreadsheet allows you to effortlessly execute complex mathematical formulas and sequential calculations in a single cell, streamlining your data processing tasks.

1. Open your data in WPS Spreadsheet: Launch WPS Office, open a new Spreadsheet, and input your base values, percentage, and divisor into separate columns.
2. Enter the formula: Select the target cell where you want the final result and type =SUM(A2:B2)*(1+C2)/D2.
3. Calculate and fill down: Press Enter to compute the result. Double-click the fill handle in the bottom-right corner of the cell to automatically apply the formula to the rest of your dataset.

Fully compatible with Microsoft Excel formulas and .xlsx file formats.Free, lightweight, and fast alternative to heavy spreadsheet applications.Intelligent formula suggestions and built-in error checking to prevent mistakes like dividing by zero.Familiar user interface that requires zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting a #DIV/0! error when using this formula?

The #DIV/0! error occurs when the divisor cell (e.g., D2) is empty or contains a zero. To fix this, ensure you have entered a valid number in the divisor cell, or wrap your formula in an IFERROR function like this: =IFERROR(SUM(A2:B2)*(1+C2)/D2, 0).

Can I use standard addition instead of the SUM function?

Yes. If you prefer not to use the SUM function for only two values, you can use the addition operator inside parentheses. The alternative formula would be =(A2+B2)*(1+C2)/D2.

How does the (1+C2) part of the formula work to increase the percentage?

In spreadsheet logic, 1 represents 100% of the original value. By adding the percentage in C2 (for example, 5% or 0.05) to 1, you get 1.05. Multiplying your sum by 1.05 correctly calculates the original total plus the 5% increase.

Will this exact formula work in WPS Spreadsheet without modifications?

Yes, WPS Spreadsheet natively supports standard Excel functions and arithmetic operators. The formula =SUM(A2:B2)*(1+C2)/D2 will work exactly the same way in WPS Spreadsheet as it does in Microsoft Excel.

Excel & Data Problems