Fix Excel Percentage Increase Formulas Above 100 Percent in WPS Office Spreadsheet
Question details
The user needs to create or correct percentage increase formulas in Excel-compatible spreadsheets so values of 100%, 150%, or more calculate correctly without #DIV/0! errors or negative results.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Calculating percentage increases in a worksheet with mixed reference cells such as $D5 and H$4, including increases at or above 100 percent.
- Observed behavior
- Formulas that divide by the percentage cell or subtract the original amount can return #DIV/0! errors or negative results when the increase is 100% or greater.
Confirm that your original amount cells and percentage cells are formatted correctly, and check whether the existing formula uses division, subtraction, or mixed references before editing.
Use the original amount multiplied by 100% plus the percentage increase
Use this formula when a percentage increase of 100%, 150%, or higher should increase the original amount instead of producing a negative or #DIV/0! result.
Percentage increase formulas fail when they divide by the percentage cell or subtract the original amount directly. Multiplying the original amount by 100% plus the increase rate gives the correct new total: a 100% increase doubles the original amount, and a 150% increase produces 2.5 times the original amount.
Click the cell where the increased amount should appear in your WPS Office spreadsheet.
Type = followed by the original amount cell reference, for example =$D5*(100%+H$4), and press Enter.
Drag the fill handle across the row and down the column to apply the formula to the rest of the table.
Replace division-based percentage increase formulas
Use this if an existing formula divides by the percentage cell or subtracts the original amount and shows #DIV/0! or a negative number.
Calculate Excel percentage increases above 100% in WPS Office Spreadsheet
Open your Excel workbook in WPS Office Spreadsheet and replace the failing formula with =OriginalAmount*(100%+PercentageCell) to get correct totals for 100%, 150%, or higher increases.
- 1. Open the Excel file in WPS Office: Launch WPS Office Spreadsheet and open the worksheet that contains the percentage increase formulas.
- 2. Select the result cell: Click the target cell where the increased amount should appear.
- 3. Enter the multiplication formula: Type =$D5*(100%+H$4) or the equivalent =OriginalAmount*(100%+PercentageCell) using your cell references, then press Enter.
- 4. Fill and verify: Drag the fill handle across and down, and confirm that 100% returns double the original amount and 150% returns 2.5 times the original amount.
Frequently Asked Questions
Why does my percentage increase formula show a negative result when the increase is 100% or more?
A common cause is subtracting the original amount from a percentage-only cell, such as =PercentageCell-OriginalAmount. Use =OriginalAmount*(100%+PercentageCell) instead; for example, =$D5*(100%+H$4).
How do I calculate a 150% increase in WPS Office Spreadsheet?
Multiply the original amount by 100% plus 150%, for example =D5*(100%+150%) or =$D5*(100%+H$4) when H4 contains 150%. The result is 2.5 times the original amount.
What does #DIV/0! mean in an Excel percentage increase formula?
It usually means the formula divides by an empty or zero percentage cell. Replace the division with multiplication: =OriginalAmount*(100%+PercentageCell).
Can I use mixed references in percentage increase formulas?
Yes. In WPS Office Spreadsheet, a formula like =$D5*(100%+H$4) locks column D and row 4 so it fills correctly across rows and down columns.
What result should a 100% increase produce?
A 100% increase doubles the original amount. For example, 200 with a 100% increase becomes 400.
