# Percentage formulas in Excel and Google Sheets

> Percent of total, percent change, adding and removing a percentage, and margins. 6 answers, each checked by running it.

Source: https://spreadsheetpractice.com/formulas/topic/percent · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on October 29, 2026

## Answers

- [How to calculate percentage change between two numbers in Excel](https://spreadsheetpractice.com/formulas/percentage-change): Subtract the old value from the new one and divide by the old: =(C2-B2)/B2, formatted as a percentage. `=(C2-B2)/B2`
- [How to calculate the percentage of a total in Excel](https://spreadsheetpractice.com/formulas/percentage-of-total): Divide each value by the total, with the total locked: =B2/SUM($B$2:$B$7), or =B2/$B$8 if the total is in a cell. `=B2/SUM($B$2:$B$7)`
- [How to add a percentage to a number in Excel](https://spreadsheetpractice.com/formulas/add-a-percentage-to-a-number): Multiply by 1 plus the percentage: =B2*(1+$E$1). To increase by 8%, multiply by 1.08. `=B2*(1+$F$1)`
- [How to subtract a percentage from a number in Excel](https://spreadsheetpractice.com/formulas/subtract-a-percentage): Multiply by 1 minus the percentage: =B2*(1-$F$1). A 15% discount is 85% of the price. `=B2*(1-$F$1)`
- [How to calculate what percentage one number is of another in Excel](https://spreadsheetpractice.com/formulas/what-percentage-of-a-number): Divide the part by the whole: =B2/C2, and format the result as a percentage. `=B2/C2`
- [How to calculate profit margin percentage in Excel](https://spreadsheetpractice.com/formulas/profit-margin): Divide profit by revenue: =(B2-C2)/B2, where B is the price or revenue and C the cost. `=(B2-C2)/B2`

More topics: [Counting formulas](https://spreadsheetpractice.com/formulas/topic/count) · [Sum formulas](https://spreadsheetpractice.com/formulas/topic/sum) · [Lookup formulas](https://spreadsheetpractice.com/formulas/topic/lookup) · [IF and logic formulas](https://spreadsheetpractice.com/formulas/topic/logic) · [Text formulas](https://spreadsheetpractice.com/formulas/topic/text) · [Date formulas](https://spreadsheetpractice.com/formulas/topic/date) · [Dynamic array formulas](https://spreadsheetpractice.com/formulas/topic/dynamic) · [Duplicates and data cleanup formulas](https://spreadsheetpractice.com/formulas/topic/cleanup) · [Rounding and math formulas](https://spreadsheetpractice.com/formulas/topic/math)

Every answer: [Formula answers](https://spreadsheetpractice.com/formulas). Formulas used: `SUM`

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.