Sum or Subtract Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!

In this Excel tutorial, we will discuss various examples of how to sum or subtract percentages. Adding or Subtracting percentages is often required while calculating discounts, sales tax, commissions, revenue growth, budgeting and expense change, etc. Now let’s delve into the examples of summing and subtracting percentages in Excel.


How to Sum Percentages in Excel

Consider the following dataset. We have unit prices and sales quantity for a few invoices. For a 5% tax, we want to calculate the total price for each invoice.

Dataset for Adding Percentage in Excel

Apply the following formula in cell E8 => Press the Enter key => Drag down the Fill Handle icon.

=(C8*D8)+(C8*D8*$E$5)

Sum or Subtract Percentages in Excel - Sum Tax Percentage


How to Subtract Percentages in Excel

Consider the following dataset. We have unit prices and sales quantity for a few invoices. For a 10% discount, we want to calculate the total price for each invoice.

Dataset for Subtracting Percentage in Excel

Apply the following formula in cell E8 => Press the Enter key => Drag down the Fill Handle icon.

=(C8*D8)-(C8*D8*$E$5)

Sum or Subtract Percentages in Excel - Subtract Discount Percentage


This concludes our article on how to sum or subtract percentages in Excel. We discussed two ideal examples that sum and subtract percentages respectively. We hope you will find this article useful. Let us know your thoughts in the comment section.


Sum or Subtract Percentages in Excel: Knowledge Hub


<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Seemanto Saha
Seemanto Saha

Seemanto Saha graduated in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. He has been with ExcelDemy for a year, where he wrote 40+ articles and reviewed 50+ articles. He has also worked on the ExcelDemy Forum and solved 50+ user problems. Currently, he is working as a team leader for ExcelDemy. His role is to guide his team to write reader-friendly content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo