Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the Wrong % error
Excel & Google SheetsWhat Wrong % means
Spreadsheets store percentages as decimals internally — 25% is stored as 0.25. When you type '25' into a cell formatted as Percentage, the display shows '2500%' because 25 * 100 = 2500%. Confusion between the raw decimal and the formatted percentage is the root cause of most wrong-percentage calculations.
Common causes
- A percentage was typed as '25' into a cell already formatted as Percentage, which displays it as 2500% instead of 25%.
- A formula multiplies a value by a percentage stored as a whole number (e.g., =A2*25) instead of the decimal equivalent (=A2*0.25 or =A2*25%).
- The Percentage format was applied after a calculation, displaying the raw decimal result (0.08) as a percentage correctly (8%) — but the user expected it in a different cell.
- A percentage difference formula uses the wrong denominator (e.g., dividing by the new value instead of the old value).
- Two cells with Percentage format are added together when the intent was to average them, or are multiplied together when only one should be the rate.
Example fix
Broken
=A2*B2Fixed
=A2*(B2/100)If B2 contains '15' (a whole number, not 0.15), multiplying directly gives 15 times A2 instead of 15% of A2. Dividing B2 by 100 converts the whole number to its decimal equivalent. The cleaner fix is to store B2 as 0.15 or '15%' (with the symbol) from the start.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Type percentages directly with the '%' symbol (e.g., 25%) into a General-formatted cell — the application stores 0.25 automatically. Do not pre-format the cell as Percentage and then type '25'.
- 2If a cell shows 2500% when you meant 25%, the cell contains 25 (not 0.25). Edit the cell and type 25% (with the symbol) or type 0.25, then format as Percentage.
- 3For percentage change calculations: =(new_value - old_value) / old_value. The old value must be the denominator. Format the result as Percentage.
- 4To calculate X% of a value: =value * percentage_cell, where percentage_cell already stores the decimal (0.25 for 25%). Do not multiply by 100 again.
- 5To add a percentage uplift: =value * (1 + percentage_cell). For a 20% increase on a value in A2 with the rate in B2: =A2*(1+B2).
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every Wrong % and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
My percentage cell shows the right number but formulas using it are wrong — why?
Check the actual stored value: format the percentage cell as Number. If it shows 25 instead of 0.25, the raw value is 25, and formulas treating it as a rate will be off by a factor of 100. Fix by retyping '25%' (with the symbol) or dividing by 100 in the formula.
What is the correct formula for percentage difference between two values?
=(new - old) / ABS(old). Using ABS() on the denominator handles cases where the old value is negative. Format the result cell as Percentage.
I formatted a cell as Percentage and now it shows 0% — the value was 0.03 and I expected 3%.
This is correct behaviour. 0.03 formatted as Percentage displays as 3%. If it shows 0%, the actual stored value is 0, not 0.03. Re-enter the value as '3%' or '0.03'.
More on Percentages
See all →How-to
How to calculate a percentage
Work out what percentage one number is of another with a simple division, then format the result as a percent. Same in Excel and Google Sheets.
How-toHow to calculate percentage change
Find the percentage increase or decrease between two numbers with (new − old) / old, then format as a percent. Works in Excel and Sheets.
How-toHow to add a percentage to a number
Increase a number by a percentage with number × (1 + rate) — handy for tax, markup, or raises. Same in both apps.
How-toHow to calculate a cumulative percentage
Use a running SUM divided by the total SUM to build a cumulative percentage column in Excel or Google Sheets.
How-toHow to calculate attendance percentage
Divide attended sessions by total sessions and multiply by 100 to get attendance percentage in Excel or Google Sheets.
How-toHow to calculate the percentage of target achieved
Divide actual results by the target goal to calculate percentage of target achieved in Excel or Google Sheets.