How to Calculate Percent Increase or Decrease / Discount in Excel

[shockersh]

Quick question for you groovy excel ppl out there. I'm working with a vendor and need to calculate the discount and/or increase. I know there is a simple excel formula I can use. Just looking for a tip for it.

Thanks!

[Steve]

Here are the formulas I use in Excel:

Percent Increase

=sum(NEW-OLD)/OLD

Percent Decrease or Discount

=sum(OLD-NEW)/OLD

Example: Let's say I bought a stock for $50 and now I'm going to sell it for $125. What is the % Increase of the stock sale? In Excel I would enter =sum(125-50)/50 and it would give me 150% increase.

For a full explanation along with screenshots, take a look at this how to tutorial: https://www.groovypost.com/howto/calculate-percentage-increases-or-decreases-in-excel/

[Simon H]

Here are the formulas I use in Excel:

Percent Increase

=sum(NEW-OLD)/OLD

Percent Decrease

=sum(OLD-NEW)/OLD

Example: Let's say I bought a stock for $50 and now I'm going to sell it for $125. What is the % Increase of the stock sale? In Excel I would enter =sum(125-50)/50 and it would give me 150% increase.

 

Nice work MrGroove. Small typo in your example though. it should be =sum(125-50)/50

[Steve]

Here are the formulas I use in Excel:

Percent Increase

=sum(NEW-OLD)/OLD

Percent Decrease

=sum(OLD-NEW)/OLD

Example: Let's say I bought a stock for $50 and now I'm going to sell it for $125. What is the % Increase of the stock sale? In Excel I would enter =sum(125-50)/50 and it would give me 150% increase.

 

Nice catch @simon H - My bad!

Thanks for catching that!

[shockersh]

Here are the formulas I use in Excel:

Percent Increase

=sum(NEW-OLD)/OLD

Percent Decrease

=sum(OLD-NEW)/OLD

Example: Let's say I bought a stock for $50 and now I'm going to sell it for $125. What is the % Increase of the stock sale? In Excel I would enter =sum(125-50)/50 and it would give me 150% increase.

 

bingo - thnx