Calculation Issues

WPS Spreadsheets: Combine a Percentage Increase and Division in One Formula

Steven Parker Nov 12, 2026 869 views

Question details

The user needs to calculate a percentage increase and then divide the increased amount in a single spreadsheet formula.

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: A principal amount must be increased by a percentage and divided by 12 without using multiple calculation steps.
Observed behavior: The calculation needs to be combined into one formula, such as applying a 3% increase to 9202.47 and dividing the result by 12.

Before you start

Confirm the principal amount and divisor, and check whether the rate is entered as a percentage such as 3% or as a decimal such as 0.03. If using cell references, identify the cells containing the principal and rate before entering the formula.

Solution 1Recommended

Combine the percentage increase and division in one WPS Spreadsheets formula

Use this method when you want to apply the increase and divide the adjusted amount in a single calculation.

Add 1 to the percentage rate to create the increase multiplier, multiply it by the principal, and then divide the result by 12. For a principal of 9202.47 and a 3% increase, the result is approximately 789.88.

Select the result cell

Open WPS Spreadsheets, select the cell where you want the calculated result to appear, and type an equals sign.

Enter the formula with fixed values

Type =(9202.47*(1+3%))/12 into the selected cell, then press Enter.

Use cell references when possible

If the principal is in A1 and the rate is in B1, enter =A1*(1+B1)/12 in the result cell and press Enter.

Check the displayed result

Confirm that the result is approximately 789.88. If the rate is stored as 3 instead of 3%, convert it to 3% or use B1/100 in the formula.

Expected result: =(9202.47*(1+3%))/12 returns approximately 789.88.

Calculate Percentage Increases and Divisions Directly in WPS Spreadsheets

WPS Spreadsheets lets you combine percentage increases, multiplication, and division in one clear formula. Use fixed values for a quick calculation or cell references for a reusable worksheet, while maintaining compatibility with Microsoft Excel workbooks.

1. Open WPS Spreadsheets: Launch WPS Office and choose Spreadsheets to create or open a workbook.
2. Prepare the input cells: Enter the principal in A1 and the percentage rate in B1, formatting B1 as a percentage if needed.
3. Enter the combined formula: Select the result cell and type =A1*(1+B1)/12, then press Enter.
4. Review and format the result: Check the calculated value and use the Home tab number-formatting controls to display the desired decimal places.

Combine the percentage increase and division in one formulaReuse the calculation with cell references for changing valuesUse a familiar spreadsheet interface with built-in formula supportOpen and save Microsoft Excel .xlsx files with compatible formatting and formulas

microsoft office alternative - wps office

Frequently Asked Questions

What formula combines a 3% increase and division by 12?

Enter =(9202.47*(1+3%))/12 in a WPS Spreadsheets cell. The result is approximately 789.88.

How do I use cell references instead of fixed numbers?

Put the principal in A1 and the rate in B1, then enter =A1*(1+B1)/12 in the result cell.

Why does my result look incorrect when I enter 3 in the rate cell?

A value of 3 represents 300% in a percentage calculation. Enter 3% or 0.03, or change the formula to =A1*(1+B1/100)/12 when B1 contains the number 3.

Can I change the divisor from 12 to another number?

Yes. Replace 12 with another divisor or reference a divisor cell, such as =A1*(1+B1)/C1 when C1 contains the divisor.

Excel & Data Problems