Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate a percentage in Excel and Google Sheets
Topic:PercentagesExcel & Google Sheets
=B2/C2Try 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
Step by step
- 1Divide the part by the total: =B2/C2 (for example, sales ÷ target).
- 2Select the cell and apply Percent format (Ctrl+Shift+5).
- 3The decimal now shows as a percentage, e.g. 0.25 becomes 25%.
Tips
- To find a value as a percent of a column total, use =B2/SUM(B:B).
- Multiply by 100 only if you are storing a plain number, not using percent formatting.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why does my percentage show as a tiny decimal?
The math is right; the cell just is not formatted as a percent. Apply Percent format (Ctrl+Shift+5) to display 0.25 as 25%.
More on Percentages
See all →How-to
How 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.
Error fixFix Wrong %
Fix wrong percentage results in Excel and Google Sheets — caused by conflating the percentage symbol with the decimal value or double-applying the % format.
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.