Step by step
- Put your numbers in cells, for example A1 = 200 and B1 = 15%.
- Type the formula from the table in another cell.
- Format the result as Percent (Ctrl+Shift+%).
At a glance
| Question | Formula | Example result |
|---|---|---|
| 15% of A1 | =A1*15% | 30 (if A1 = 200) |
| A1 as a percent of B1 | =A1/B1, format as % | 25% |
| Change from A1 to B1 | =(B1-A1)/A1, format as % | +25% |
Related questions
Why does Excel show 0.25 instead of 25%?
The cell is formatted as a number; switch it to Percent.
Why do I get 1500% instead of 15%?
You typed 15 in a percent-formatted cell after multiplying by 100; use =A1/B1 without ×100.
Are the formulas the same in Google Sheets?
Yes, they work the same.
More questions: percentage calculator
- How to find a percentage of a number
- How to calculate a percentage increase
- How to calculate a discount or percentage decrease
- Percentage change vs percentage difference between two numbers
- What percent is one number of another?
- How to add or subtract a percentage (tax, tip, raise)
- How to calculate a percentage on the iPhone Calculator
- How to calculate a percentage on an Android phone calculator
- How to calculate percentages on the Windows and Mac Calculator
- How to calculate percentages in your head
- How to turn test scores into a percentage
- How to calculate profit margin and markup percentage
- What is a percentage and how does it work?
- Can a percentage be negative or over 100%?
Open the full percentage calculator →
Updated November 14, 2026.