Percentage in Excel
Basic Percentage Formula
In Excel, enter =A1*B1 where A1 contains the number and B1 contains the percentage as a decimal (0.15 for 15%). Or use =A1*15/100 directly.
To format a cell as a percentage, select the cell and press Ctrl+Shift+5 or go to Format → Cells → Percentage.
Common Excel Percentage Formulas
| Task | Formula |
|---|---|
| X% of a number | =A1*B1/100 |
| What % is A of B | =A1/B1 (format as %) |
| % Change | =(B1-A1)/A1 (format as %) |
| Add tax to price | =A1*(1+B1/100) |
| Apply discount | =A1*(1-B1/100) |
| % of total | =A1/SUM($A$1:$A$10) (format as %) |
Tips
When you format a cell as "Percentage" in Excel, it multiplies the value by 100 for display. So entering 0.15 shows as 15%. If you type "15" and format as percentage, it shows 1500%. This is the most common mistake.
All of these formulas work identically in Google Sheets. Practice with our percentage calculator first to understand the math, then apply in your spreadsheet.
More Percentage Tools
Why Percentages Matter
Percentages are one of the most widely used mathematical concepts in everyday life. From calculating sales tax and tips to understanding interest rates, investment returns, and statistical data, percentage literacy is essential for making informed financial and academic decisions.
In finance: Interest rates, investment returns, inflation, and tax rates are all expressed as percentages. A 1% difference in mortgage interest on a $300,000 loan amounts to roughly $60,000 over 30 years. Understanding percentages helps you make better financial decisions.
In academics: Grades, test scores, and statistical significance are percentage-based. Knowing how to convert between fractions, decimals, and percentages is fundamental to math, science, and data analysis courses.
In business: Profit margins, market share, growth rates, and discount structures all rely on percentage calculations. Being able to quickly calculate and interpret percentages is a core professional skill in virtually every field.
Use our free percentage tools above to handle any calculation quickly and accurately. Whether you need to find what percentage one number is of another, calculate a percentage increase or decrease, or convert between fractions and percentages, we have a tool for it.
Working with Percentages in Spreadsheets
Percentage calculations in Excel and other spreadsheet applications follow specific formatting rules that can trip up users unfamiliar with how cell formats interact with formulas. When you format a cell as a percentage, Excel displays the value multiplied by 100 with a percent sign — so entering 0.15 shows as 15%, while entering 15 in a percentage-formatted cell displays as 1500%. Understanding this behavior prevents calculation errors in financial models, data analysis, and reporting where percentage accuracy is critical.
Common spreadsheet percentage operations include calculating percentage change between periods (new minus old divided by old), computing percentage of total (individual value divided by the sum), applying percentage increases or decreases to values, and using percentage-based conditional formatting to highlight data that meets threshold criteria. Our guide covers the exact formulas and cell format settings you need for each scenario, with examples that work in Excel, Google Sheets, and other spreadsheet applications. Learning these patterns once saves hours of troubleshooting formula errors across all your future spreadsheet work.