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.
Helpful context
This page is designed to give you a quick answer and a readable explanation so you can verify the math without bouncing between multiple tabs or guessing which formula applies.
Practical example
The Percentage in Excel page is also a good double-check when you are moving between calculator results and spreadsheet work. Many people know the rough idea of the math but still make small setup errors when a value needs to be rounded, reformatted, or interpreted in context. Keeping the explanation tied to the specific percentage in excel workflow makes those mistakes easier to catch.
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.