ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Formula > How to Add/Subtract Percentage in Excel

How to Add/Subtract Percentage in Excel

How to Add/Subtract Percentage in Excel
Table of contents :
  • Add Percentage in Excel
  • Subtract Percentage in Excel

How to Add and Subtract Percentage in Excel

Add Percentage in Excel

What is the price of each cell phone after the price increase?

Add Percentage in Excel

You can use the multiplication and addition formula to get prices after a percentage increase.

The Formula

=number*(1+percentage_increase)

How does the formula work?

=B2*(1+C2)

The first calculated formula is (1+C2). Why should the discount percentage add to the number 1?

If the percentage of the discount is directly multiplied by the price, then you got the increased value, not the price after the increase. That is why it must be added with number 1.

The result is 1 + 20% = 1.2, then multiplied by the price of a cellphone.

The result is $140.99 * 1.2 = $169.19

Subtract Percentage in Excel

What is the price of each cell phone after the discount?

Subtract Percentage in Excel

The given percentage is the discount percentage. If you directly multiply the price and the discount, then you got the discount value, not the price after discount.

To find out the price after the discount, the discount percentage must be deducted by number 1; the new result is multiplied by the price to get the price after the discount.

The Formula

=number*(1-percentage_decrease)

How does the formula work?

=B2*(1-C2)

First, Excel will calculate the formula (1-C2). Number 1 is subtracted by the percentage discount. Cell C2 contains the number 20% equal to the 0.2 value.

The result is 0.8, which is then multiplied by the price of the cellphone in cell B2, $140.99*0.8. The result is $112.79.

How to get the original number after adding/subtracting percentages in excel? Read the following article:

  • Get the Original Price from Percentage Increase/Decrease

Related Article

Articles related to this article
  • How to Subtract in Excel
  • How to Do Multiplication in Excel
  • How to Do Division in Excel
Usefull links
  • Microsoft Multiply by a percentage documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

How to Create a Formula in Excel
How to Create a Simple Formula in Excel To create …

How to Create a Formula in Excel

Calculate Number of Days, Weeks, Months and Years between Two Dates
Calculate Number of Days Between Two Dates Excel has a …

Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel

VLOOKUP MATCH
VLOOKUP MATCH – Solution for VLOOKUP REF Error The article …

VLOOKUP MATCH – a Combination for a Solution

How to Determine If a Number is Even or Odd
What are Odd and Even Numbers? Even numbers definition Even …

How to Determine If a Number is Even or Odd

How to Convert Time to Hours, Minutes and Seconds in Excel
Excel stores TIME values in decimal numbers, but in day …

How to Convert Time to Hours, Minutes and Seconds in Excel

Tags:Add Percentage in Excel Division Formula How to Add a Percentage in Excel How to Subtract a Percentage in Excel Multiplication Formula Subtract Percentage in Excel Subtraction Formula

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2021 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh