--- title: "How to calculate percentages in Excel, with every formula | PracticeExcel" description: "Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes." canonical_url: "https://practiceexcelonline.com/learn/calculate-percentage-excel" locale: en meta: "og:description": "Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SG93IHRvIGNhbGN1bGF0ZSBwZXJjZW50YWdlcyBpbiBFeGNlbCwgd2l0aCBldmVyeSBmb3JtdWxh%2Cdescription_~RXZlcnkgcGVyY2VudGFnZSBmb3JtdWxhIHlvdSBuZWVkIGluIEV4Y2VsLCBmcm9tIHBlcmNlbnQgb2YgYSBudW1iZXIgYW5kIHBlcmNlbnQgY2hhbmdlIHRvIGRpc2NvdW50cywgbWFyZ2lucyBhbmQgYWRkaW5nIG9yIHJlbW92aW5nIFZBVCwgd2l0aCB0aGUgdXN1YWwgbWlzdGFrZXMu%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9jYWxjdWxhdGUtcGVyY2VudGFnZS1leGNlbCI%2Cs_yuspAAvUauY1mTOo.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "How to calculate percentages in Excel, with every formula | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SG93IHRvIGNhbGN1bGF0ZSBwZXJjZW50YWdlcyBpbiBFeGNlbCwgd2l0aCBldmVyeSBmb3JtdWxh%2Cdescription_~RXZlcnkgcGVyY2VudGFnZSBmb3JtdWxhIHlvdSBuZWVkIGluIEV4Y2VsLCBmcm9tIHBlcmNlbnQgb2YgYSBudW1iZXIgYW5kIHBlcmNlbnQgY2hhbmdlIHRvIGRpc2NvdW50cywgbWFyZ2lucyBhbmQgYWRkaW5nIG9yIHJlbW92aW5nIFZBVCwgd2l0aCB0aGUgdXN1YWwgbWlzdGFrZXMu%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9jYWxjdWxhdGUtcGVyY2VudGFnZS1leGNlbCI%2Cs_yuspAAvUauY1mTOo.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **How to calculate percentages in Excel: percent of a number, change, discount and VAT** Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes. By Nicolaj Gajhede, founder of PracticeExcel · Updated November 1, 2026 · 11 min read A percentage in Excel is an ordinary number. 25% is 0.25, 100% is 1, and the percent sign is only a format that multiplies the number by 100 on screen. Once you see it that way, every percentage question turns into multiplying or dividing by that number, and each kind of question has one short formula. This guide has them all: a percent of a number, adding and removing a percentage, the VAT or sales tax inside a price, discounts, what percent one number is of another, percent change, margin and markup, and percentage points. Each comes with an example you can read cell by cell, and an exercise where you write it yourself. ## Every formula on one page | **You want** | **Formula** | **Example** | | --- | --- | --- | | A percent of a number | `**=B2*C2**` | 25% of 800 is 200 | | Add a percentage | `**=B2*(1+C2)**` | 800 plus 25% is 1,000 | | Remove a percentage that was added | `**=B2/(1+C2)**` | 1,000 without 25% VAT is 800 | | The tax inside a total | `**=B2-B2/(1+C2)**` | The VAT in 1,000 is 200 | | Take a percentage off | `**=B2*(1-C2)**` | 600 less 25% is 450 | | What percent one number is of another | `**=B2/C2**` | 45 of 60 is 75% | | Percent change | `**=(C2-B2)/B2**` | 1,200 to 1,500 is 25% | | Profit margin | `**=(B2-C2)/B2**` | Price 200, cost 130 is 35% | In each formula, B2 is the number you start from and C2 holds the percentage or the second number. Format the result as a percentage when it's a share or a change, and as a number when it's an amount. ## How Excel stores a percentage Type 25% into a cell, and Excel stores 0.25 and shows it with the Percent format. Type 0.25 and press [**Ctrl+Shift+5**](https://practiceexcelonline.com/shortcuts/percent-format), and you get the same thing. Both cells hold the same number, and formulas see 0.25 either way. That's why a formula never needs to divide by 100. `**=B2*25%**` is the same as `**=B2*0.25**`, and if C2 holds 25%, `**=B2*C2**` already multiplies by 0.25. The trap is the other way around. Type 25 into a cell, then format it as a percentage, and Excel shows 2500%, because 25 is 25 whole units. If a column of rates came in as whole numbers, divide them by 100 once, or type them again with the % sign. The Percent format also rounds what you see. 0.125 shows as 13% with no decimals, while the cell still holds 0.125. Click **Increase Decimal** on the Home tab to show 12.5%. Formulas always use the full number, whatever the cell shows. One more habit pays off in every section below: put the rate in its own cell. A VAT rate, a discount or a target typed into a formula is hidden, and it has to be changed in every formula when it changes. A rate in a labeled cell is visible, and one change updates everything. ## A percent of a number To find a percent of a number, multiply. With the price in B2 and the VAT rate in E1, the VAT on the printer is: C2=B2\*$E$1 | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Item | Price excl. VAT | VAT | VAT rate | 0.25 | | 2 | Printer | 800 | **200** | | | | 3 | Monitor | 1800 | | | | 25% of 800 is 200. The rate sits in E1, and the $ signs keep it there when you fill the formula down. The $ signs lock E1, so the formula still points at the rate when you fill it down to the monitor and the rest. Without them, the copy in C3 would point at E2, which is empty, and give 0. Press F4 while the cursor is in E1, and Excel adds the $ signs for you. The same formula answers any question of the form "what is 15% of this?": a tip, a commission, a deposit, a bonus. Multiply the amount by the rate. ## Add a percentage To add a percentage, such as VAT, sales tax or a markup, you could work out the amount and add it: `**=B2+B2*$E$1**`. It's shorter to multiply by 1 plus the rate: C2=B2\*(1+$E$1) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Item | Price excl. VAT | Price incl. VAT | VAT rate | 0.25 | | 2 | Printer | 800 | **1000** | | | | 3 | Monitor | 1800 | | | | Multiplying by 1 plus the rate keeps the price and adds 25% in one step: 800 becomes 1,000. The 1 keeps the price and the 0.25 adds the VAT, so 800 × 1.25 = 1,000. The parentheses matter. Without them, Excel multiplies first and then adds 0.25 to the result. VAT and sales tax work the same way. The examples here use 25%, the VAT rate in Denmark, and a sales tax of 8% is just 0.08 in the rate cell. Practice it in [**add VAT to a price**](https://practiceexcelonline.com/practice/percentages/add-vat), and the same formula with a markup on a cost price in [**add a markup to a cost price**](https://practiceexcelonline.com/practice/percentages/add-percentage-markup). ## Remove a percentage that was added Going back is where most people go wrong. A price of 1,000 includes 25% VAT, and you want the price before VAT. Taking 25% off gives 750, which is wrong, because the VAT was 25% of the price before VAT, not of the total. Divide by 1 plus the rate instead: C2=B2/(1+$E$1) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Item | Price incl. VAT | Price excl. VAT | VAT rate | 0.25 | | 2 | Printer | 1000 | **800** | | | | 3 | Monitor | 2250 | | | | Going back means dividing by 1 plus the rate. 1,000 divided by 1.25 is 800, the price before VAT. Check it: 800 plus 25% of 800 is 1,000. The rule works for anything that was added as a percentage. A price that includes a 10% service charge is divided by 1.1, and a salary after a 4% raise is divided by 1.04 to get last year's salary. Practice it in [**find the price before VAT**](https://practiceexcelonline.com/practice/percentages/price-before-vat). ## The VAT inside a total Sometimes you need the tax itself, for example to fill in a VAT return from a list of receipts. It's the total minus the price before VAT: C2=B2-B2/(1+$E$1) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Item | Price incl. VAT | VAT | VAT rate | 0.25 | | 2 | Printer | 1000 | **200** | | | | 3 | Monitor | 2250 | | | | The VAT inside a price of 1,000 is the price minus the price before VAT: 200, which is 20% of the total. Notice that the VAT is 200 of 1,000, which is 20% of the total. With 25% VAT, the tax is always a fifth of a price that includes it, so `**=B2*0.2**` gives the same result. It breaks the day the rate changes, though, so the version with E1 is safer. At 20% VAT, the tax is a sixth of the total, and at 8% sales tax it's 0.08 / 1.08 of it. The exercise [**find the VAT in a price that includes it**](https://practiceexcelonline.com/practice/percentages/vat-in-price) drills the full formula. ## Rounding to the cent Percentages rarely come out even. 25% VAT on 79.99 is 19.9975, and a price with VAT of 99.9875 shows as 99.99 but still holds every decimal. Add up a column of those, and the total can be a cent off from the receipts. Round where the money is rounded, usually per line: `**=ROUND(B2*(1+$E$1),2)**`. ROUND with 2 rounds to two decimals, and the cell then holds exactly 99.99. The [**guide to Excel for finance**](https://practiceexcelonline.com/learn/excel-for-finance) explains when to round per line and when to round the total, and [**round a price to two decimals**](https://practiceexcelonline.com/practice/round/round-two-decimals) is the exercise. ## Take a percentage off A discount takes a percentage off the price. Multiply by 1 minus the discount: D2=B2\*(1-C2) | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Item | Price | Discount | | | 2 | Jacket | 600 | 0.25 | **450** | | 3 | Boots | 900 | 0.1 | | 25% off 600 means paying 75% of it, which is 450. 25% off means paying 75%, so 600 × 0.75 = 450. The long version, `**=B2-B2*C2**`, gives the same answer. Two discounts in a row multiply: 20% off and then another 10% off is `**=B2*(1-20%)*(1-10%)**`, which is 28% off in total, not 30%. Try it in [**sale price after a discount**](https://practiceexcelonline.com/practice/percentages/price-after-discount). The reverse works like VAT. If a jacket costs 450 after 25% off, the original price is `**=B2/(1-C2)**`, which is 450 / 0.75 = 600. Adding 25% back on would give 562.50, because the 25% was taken off the original price, not the sale price. ## Change a whole column by a percentage To raise every price in a column by 10% without a helper column, let Paste Special do the multiplying. Type 1.1 in an empty cell and copy it. Select the prices, press [**Ctrl+Alt+V**](https://practiceexcelonline.com/shortcuts/paste-special), choose **Multiply** and click OK. Every selected cell is now 10% higher, and you can delete the 1.1. The change overwrites the old values, so it suits a one-off update of a price list better than a model you'll change again. For anything you might want to adjust, keep the old prices, put the increase in its own cell and use `**=B2*(1+$E$1)**` in a new column. Changing E1 then reprices everything, and the old prices are still there to compare with. ## What percent one number is of another To find what percent one number is of another, divide the part by the whole: D2=B2/C2 | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Task | Done | Total | | | 2 | Invoices | 45 | 60 | **0.75** | | 3 | Reminders | 12 | 40 | | 45 of 60 invoices are done. 45 divided by 60 is 0.75, which shows as 75% in the Percent format. The part goes on top. 45 of 60 is 45/60, and 60/45 would say 133%, which answers a different question. Format the result as a percentage, and the 0.75 shows as 75%. When each row is a share of the same total, lock the total: `**=B2/$B$10**` with the total in B10, or `**=B2/SUM($B$2:$B$9)**` without a total row. That's the formula behind every "% of total" column and every pie chart. It's drilled in [**each region's share of the total**](https://practiceexcelonline.com/practice/summary-tables/summary-table-share-of-total), and the [**guide to pivot tables**](https://practiceexcelonline.com/learn/pivot-tables) shows the same calculation as % of Grand Total. The same division measures progress against a target. Sales of 56,000 against a target of 50,000 is `**=B2/C2**`, or 112%, so the target was beaten by 12%. What's left to go is 1 minus the share: with 45 of 60 invoices done, `**=1-B2/C2**` gives 25% still open. A share above 100% is fine here. It only means the part is bigger than the whole you compare it with, which is exactly what beating a target means. ## Percent change Percent change compares a new value with an old one. Subtract the old from the new, and divide by the old: D2=(C2-B2)/B2 | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Product | Last year | This year | | | 2 | Coffee | 1200 | 1500 | **0.25** | | 3 | Tea | 800 | 720 | | Sales went from 1,200 to 1,500. The change is 300, and 300 of the old 1,200 is a 25% increase. Divide by the old value, the one you're comparing against. 300/1,500 would say 20%, which is the drop you'd need to go back from 1,500 to 1,200, not the increase. Tea went from 800 to 720, and the same formula gives -10%, a decrease. Fill it down, and positive numbers are growth and negative numbers are decline. `**=C2/B2-1**` is the same calculation in fewer characters, and you'll see both in real workbooks. If the old value can be 0, the formula gives #DIV/0!, since nothing can grow by a percentage from zero. Show a blank instead with `**=IF(B2=0,"",(C2-B2)/B2)**`. The [**guide to IF**](https://practiceexcelonline.com/learn/excel-if-function) has more ways to handle cases like that. Practice the basic version in [**percent change from last year**](https://practiceexcelonline.com/practice/percentages/percent-change). ### Growth over several years Percent change over several years can't be divided evenly between them. Sales that grew from 1,000 to 1,500 over five years grew 50%, but not 10% a year, since each year's growth builds on the year before. The average yearly growth is `**=(C2/B2)^(1/5)-1**`, which is about 8.4%. Check it the other way: 1,000 × 1.084 five times is close to 1,500. Finance calls this the compound annual growth rate, CAGR. To project the other way, grow a value by the same percentage for several years with `**=B2*(1+C2)^5**`, where C2 holds the yearly growth and 5 is the number of years. ### Show a plus sign on increases A column of changes is easier to read when increases have a plus sign. Select the cells, press [**Ctrl+1**](https://practiceexcelonline.com/shortcuts/format-cells), choose Custom and type the format **+0%;-0%;0%**. The three parts are for positive numbers, negative numbers and zero, so 0.25 shows as +25% and -0.1 as -10%. For a color on top, add Green and Red in front of the first two parts, or use [**conditional formatting**](https://practiceexcelonline.com/learn/conditional-formatting-excel). ## Margin and markup Margin and markup both start from the same profit, the price minus the cost, but they divide it by different numbers. Margin divides by the price: D2=(B2-C2)/B2 | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Product | Price | Cost | | | 2 | Lamp | 200 | 130 | **0.35** | | 3 | Rug | 400 | 300 | | Sold for 200 at a cost of 130, the profit is 70. As a share of the price, that is a 35% margin. Markup divides by the cost instead: `**=(B2-C2)/C2**`, which gives 54% for the same lamp. A 35% margin and a 54% markup describe the same sale, so always say which one you mean. Retail and finance usually talk about margin, and pricing from a cost price usually uses markup. To set a price that gives a target margin, divide the cost by 1 minus the margin: `**=C2/(1-D2)**` with the target margin in D2. A cost of 130 and a 35% margin give a price of 200. Practice it in [**profit margin from price and cost**](https://practiceexcelonline.com/practice/percentages/profit-margin). ## Percentage points When the numbers you compare are already percentages, there are two kinds of change. Subtracting them gives the difference in percentage points: D2=C2-B2 | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Page | Before | After | | | 2 | Checkout | 0.5 | 0.75 | **0.25** | | 3 | Sign-up | 0.2 | 0.3 | | From 50% to 75% is 0.25, or 25 percentage points. As a percent change, it would be a 50% increase. A conversion rate that goes from 50% to 75% has risen by 25 percentage points. As a percent change, with `**=(C2-B2)/B2**`, it has risen by 50%. Both are correct, and they answer different questions, so reports should say which one they use. "Up 25 points" and "up 50%" mean the same thing here, and mixing them up makes a change look twice or half as big. ## Averages of percentages Averaging a column of percentages gives the wrong answer when the rows have different sizes. If one team finished 45 of 60 invoices, 75%, and another finished 12 of 40, 30%, the average of the two percentages is 52.5%. But together they finished 57 of 100, which is 57%. For an overall percentage, add up the parts and the wholes first and then divide: `**=SUM(B2:B5)/SUM(C2:C5)**`. Use the plain average of percentages only when each row should count the same, whatever its size. ## Common mistakes - **Typing 25 instead of 25%.** The cell holds 25, so a formula multiplies by 25, not by a quarter. Type the % sign, or 0.25. - **Taking a percentage off to remove VAT.** 1,000 × 0.75 = 750 takes off too much. Divide by 1.25 to get 800. - **Forgetting the parentheses.** `**=B2*1+C2**` multiplies by 1 and then adds the rate. Write `**=B2*(1+C2)**`. - **Dividing by the wrong number.** Percent change divides by the old value, and a share divides by the whole. - **A rate that moves when you fill down.** Lock the rate cell with $, or every row after the first points at an empty cell and gives 0. - **Adding up percentages.** 10% of one thing plus 10% of another isn't 20% of anything. Add up the amounts, then divide. - **A number formatted as percent that looks rounded.** The cell shows 13%, but formulas use 0.125. Add decimals with Increase Decimal, or round the number with ROUND if the rounded value is what you want. ## Percentages in Google Sheets Every formula in this guide works unchanged in Google Sheets. Format a cell as a percentage with **Format > Number > Percent** or the % button on the toolbar. Sheets also has a TO\_PERCENT function, but the plain formulas above are easier to read and work in both programs. See [**Google Sheets or Excel**](https://practiceexcelonline.com/learn/google-sheets-vs-excel) for the other differences. ## Percentages in Excel tests Percentages turn up in almost every employer Excel test, usually as one row of a larger task: the change from last year, the share of the total, a price with VAT or after a discount. The math is quick, so the points are lost on details. Lock the rate cell before you fill down, divide by the old value for a change, divide by 1 plus the rate to remove VAT, and format the answer as a percentage when the task asks for one. Check the first row by hand before you fill the formula down. ## In short Excel stores 25% as 0.25, so percentages are just multiplication and division. Multiply by the rate for a percent of a number, by 1 plus the rate to add it and by 1 minus the rate to take it off. Divide by 1 plus the rate to remove VAT or anything else that was added. Divide the part by the whole for a share, and the change by the old value for a percent change. Keep the rate in its own cell, lock it with $, and format the answer as a percentage when it's a share. The exercises below drill each formula on a small sheet, from the change since last year to the VAT in a price and a profit margin. Try the first one for free, and write the formula yourself. ![Nicolaj Gajhede](https://practiceexcelonline.com/authors/nicolaj-gajhede.webp) **About the author** ## **Nicolaj Gajhede**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself. [Nicolaj Gajhede on LinkedIn](https://www.linkedin.com/in/nicolaj-gajhede/) [More about Nicolaj Gajhede](https://practiceexcelonline.com/about#nicolaj-gajhede) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**Percent change from last year**Percentages →](https://practiceexcelonline.com/practice/percentages/percent-change) - [**Add a markup to a cost price**Percentages →](https://practiceexcelonline.com/practice/percentages/add-percentage-markup) - [**Sale price after a discount**Percentages →](https://practiceexcelonline.com/practice/percentages/price-after-discount) - [**Find the price before VAT**Percentages →](https://practiceexcelonline.com/practice/percentages/price-before-vat) - [**Add VAT to a price**Percentages →](https://practiceexcelonline.com/practice/percentages/add-vat) - [**Find the VAT in a price that includes it**Percentages →](https://practiceexcelonline.com/practice/percentages/vat-in-price) - [**Profit margin from price and cost**Percentages →](https://practiceexcelonline.com/practice/percentages/profit-margin) - [**Each region's share of the total**Summary tables →](https://practiceexcelonline.com/practice/summary-tables/summary-table-share-of-total) ### **Function pages** - [**ROUND**](https://practiceexcelonline.com/functions/round) ## **Questions**
### How do I calculate a percentage in Excel? Divide the part by the whole and format the cell as a percentage. For 45 out of 60, =B2/C2 gives 0.75, and Ctrl+Shift+5 shows it as 75%.
### What is the formula for percentage increase in Excel? Subtract the old value from the new one and divide by the old one, =(C2-B2)/B2. From 1,200 to 1,500 that is 0.25, or 25%. A negative result is a decrease.
### How do I add a percentage to a number in Excel? Multiply by 1 plus the percentage, =B2\*(1+C2). To add 25% to 800, that is 800 × 1.25 = 1,000.
### How do I subtract a percentage in Excel? Multiply by 1 minus the percentage, =B2\*(1-C2). 25% off 600 is 600 × 0.75 = 450. To remove a percentage that was added, such as VAT, divide by 1 plus the percentage instead.
### How do I remove VAT or sales tax from a price in Excel? Divide by 1 plus the tax rate, =B2/(1+$E$1) with the rate in E1. A price of 1,000 with 25% VAT is 800 before VAT. Multiplying by 0.75 takes off too much.
### Why does Excel show 2500% when I type 25? The cell has the Percent format, and Excel stores 25 as twenty-five whole units, which is 2500%. Type 25% or 0.25 instead, or format the cell as a percentage before you type.
## **More guides** - [**Excel for finance and accounting: the skills you actually use**The Excel skills finance and accounting teams use every day, from SUMIFS on a ledger and budget variances to rounding, month-end dates, PMT, NPV and check totals.](https://practiceexcelonline.com/learn/excel-for-finance) - [**Pivot tables explained, and the formulas that do the same job**What a pivot table computes, how to build one step by step, the problems that trip people up, and how to get the same summaries with SUMIF, COUNTIF and SUMIFS.](https://practiceexcelonline.com/learn/pivot-tables) - [**Excel IF formulas: from one condition to many**How IF works, how to combine conditions with AND and OR, when to nest IFs or switch to IFS, and how to fix the IF mistakes that give wrong answers without an error.](https://practiceexcelonline.com/learn/excel-if-function) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#webpage","dateModified":"2026-11-01","datePublished":"2026-11-01","description":"Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes.","name":"How to calculate percentages in Excel, with every formula","url":"https://practiceexcelonline.com/learn/calculate-percentage-excel","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/5"},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/6"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/calculate-percentage-excel"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"How to calculate percentages in Excel, with every formula","position":3}]},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#article","@type":"Article","dateModified":"2026-11-01","datePublished":"2026-11-01","description":"Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes.","headline":"How to calculate percentages in Excel, with every formula","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SG93IHRvIGNhbGN1bGF0ZSBwZXJjZW50YWdlcyBpbiBFeGNlbCwgd2l0aCBldmVyeSBmb3JtdWxh%2Cdescription_~RXZlcnkgcGVyY2VudGFnZSBmb3JtdWxhIHlvdSBuZWVkIGluIEV4Y2VsLCBmcm9tIHBlcmNlbnQgb2YgYSBudW1iZXIgYW5kIHBlcmNlbnQgY2hhbmdlIHRvIGRpc2NvdW50cywgbWFyZ2lucyBhbmQgYWRkaW5nIG9yIHJlbW92aW5nIFZBVCwgd2l0aCB0aGUgdXN1YWwgbWlzdGFrZXMu%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9jYWxjdWxhdGUtcGVyY2VudGFnZS1leGNlbCI%2Cs_yuspAAvUauY1mTOo.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I calculate a percentage in Excel?","acceptedAnswer":{"@type":"Answer","text":"Divide the part by the whole and format the cell as a percentage. For 45 out of 60, =B2/C2 gives 0.75, and Ctrl+Shift+5 shows it as 75%."}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is the formula for percentage increase in Excel?","acceptedAnswer":{"@type":"Answer","text":"Subtract the old value from the new one and divide by the old one, =(C2-B2)/B2. From 1,200 to 1,500 that is 0.25, or 25%. A negative result is a decrease."}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I add a percentage to a number in Excel?","acceptedAnswer":{"@type":"Answer","text":"Multiply by 1 plus the percentage, =B2*(1+C2). To add 25% to 800, that is 800 × 1.25 = 1,000."}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I subtract a percentage in Excel?","acceptedAnswer":{"@type":"Answer","text":"Multiply by 1 minus the percentage, =B2*(1-C2). 25% off 600 is 600 × 0.75 = 450. To remove a percentage that was added, such as VAT, divide by 1 plus the percentage instead."}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"How do I remove VAT or sales tax from a price in Excel?","acceptedAnswer":{"@type":"Answer","text":"Divide by 1 plus the tax rate, =B2/(1+$E$1) with the rate in E1. A price of 1,000 with 25% VAT is 800 before VAT. Multiplying by 0.75 takes off too much."}},{"@id":"https://practiceexcelonline.com/learn/calculate-percentage-excel#/schema/question/6","@type":"Question","inLanguage":"en-US","name":"Why does Excel show 2500% when I type 25?","acceptedAnswer":{"@type":"Answer","text":"The cell has the Percent format, and Excel stores 25 as twenty-five whole units, which is 2500%. Type 25% or 0.25 instead, or format the cell as a percentage before you type."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself.","jobTitle":"founder of PracticeExcel","name":"Nicolaj Gajhede","url":"https://practiceexcelonline.com/about#nicolaj-gajhede","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"},"sameAs":["https://www.linkedin.com/in/nicolaj-gajhede/"]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SG93IHRvIGNhbGN1bGF0ZSBwZXJjZW50YWdlcyBpbiBFeGNlbCwgd2l0aCBldmVyeSBmb3JtdWxh%2Cdescription_~RXZlcnkgcGVyY2VudGFnZSBmb3JtdWxhIHlvdSBuZWVkIGluIEV4Y2VsLCBmcm9tIHBlcmNlbnQgb2YgYSBudW1iZXIgYW5kIHBlcmNlbnQgY2hhbmdlIHRvIGRpc2NvdW50cywgbWFyZ2lucyBhbmQgYWRkaW5nIG9yIHJlbW92aW5nIFZBVCwgd2l0aCB0aGUgdXN1YWwgbWlzdGFrZXMu%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9jYWxjdWxhdGUtcGVyY2VudGFnZS1leGNlbCI%2Cs_yuspAAvUauY1mTOo.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SG93IHRvIGNhbGN1bGF0ZSBwZXJjZW50YWdlcyBpbiBFeGNlbCwgd2l0aCBldmVyeSBmb3JtdWxh%2Cdescription_~RXZlcnkgcGVyY2VudGFnZSBmb3JtdWxhIHlvdSBuZWVkIGluIEV4Y2VsLCBmcm9tIHBlcmNlbnQgb2YgYSBudW1iZXIgYW5kIHBlcmNlbnQgY2hhbmdlIHRvIGRpc2NvdW50cywgbWFyZ2lucyBhbmQgYWRkaW5nIG9yIHJlbW92aW5nIFZBVCwgd2l0aCB0aGUgdXN1YWwgbWlzdGFrZXMu%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9jYWxjdWxhdGUtcGVyY2VudGFnZS1leGNlbCI%2Cs_yuspAAvUauY1mTOo.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.