Formula Errors

Fix Excel #VALUE! Error When Calculating 15 Percent and Adding to Total

Maira Mehtab Oct 10, 2026 868 views

Question details

The user needs a formula to calculate 15% of a specific cell's value and add that amount to the original value, but their current SUM formula is causing a #VALUE! error.

How to Calculate 15 Percent and Add It to a Total in Excel

Product: Excel
Device & OS: not provided
Scenario: Calculating a percentage of a base numerical value and summing them together for a final total.
Observed behavior: Attempting to calculate the percentage using formulas like =SUM(N31*0.15) results in a #VALUE! error in both the percentage and total cells.

Before you start

Ensure that the base cell containing your original value (e.g., N31) is formatted as a Number or Currency and does not contain any hidden text, spaces, or non-numeric characters.

Solution 1Recommended

Calculate the Percentage and Total in Separate Cells

Breaking down the calculation into two straightforward steps makes it easier to track the exact percentage amount and prevents complex syntax errors like #VALUE!.

By calculating the 15 percent margin in one cell and adding it to the base cell in another, you ensure the logic remains clean. The #VALUE! error typically occurs when a mathematical operation is performed on a cell that Excel interprets as text, or when the SUM function syntax is misused.

Calculate the 15 percent amount

Select the cell where you want the 15 percent value to appear (e.g., O31). Type the formula =N31*15% or =N31*0.15 and press Enter.

Calculate the final total

Select the cell for your final total (e.g., P31). Type the formula =N31+O31 or =SUM(N31,O31) and press Enter.

Verify results

Check both cells to ensure the numbers calculate properly. If the #VALUE! error persists, clear the formatting of cell N31 and re-enter the number manually.

Calculate the Percentage and Total in Separate Cells

Data Type Tip: Using the plus sign (+) for addition often bypasses minor syntax issues compared to nesting mathematical operations inside a SUM formula.

Solution 2

Use a Single Formula to Add 15 Percent

If you do not need to display the 15 percent amount separately, you can calculate the final total directly in one cell using a multiplier.

Efficient Spreadsheet Calculations

Calculate Percentages and Sums Seamlessly with WPS Spreadsheet

WPS Spreadsheet provides full compatibility with Excel formulas, making it incredibly easy to calculate percentages, totals, and quickly troubleshoot #VALUE! errors using intuitive built-in functions.

1. Open your workbook: Launch WPS Spreadsheet and open the document containing your data.
2. Enter the percentage formula: Click the target cell and type =N31*1.15 to calculate the total directly, or split it using =N31*15%.
3. Apply to multiple rows: Hover over the bottom-right corner of the cell until the crosshair appears, then drag downward to apply the calculation to the rest of the column.

100% compatible with Microsoft Excel formulas, including SUM and percentage formatting.Built-in error checking mechanisms to quickly identify and fix #VALUE! data type errors.Free, lightweight, and user-friendly interface for all everyday spreadsheet calculations.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my percentage formula return a #VALUE! error?

The #VALUE! error usually occurs because the referenced cell contains text strings, hidden spaces, or special characters instead of pure numeric values. Misusing the syntax, such as typing =SUM(A1*0.15) on a non-numeric cell, forces Excel to return an error because it cannot perform arithmetic on text.

How do I calculate a different percentage, like 20%?

You can simply replace 15% with 20% in your formula. For example, use =N31*20% to find the percentage amount, or use =N31*1.20 to calculate the original value plus the 20% increase in a single step.

Can I apply this 15% calculation to an entire column at once?

Yes. Once you enter the correct formula in the first cell and press Enter, click the small square at the bottom-right corner of that cell (the fill handle) and drag it down the column. Excel will automatically adjust the row numbers for the rest of the calculations.

WPS Office