login about faq
1
1

Quick question for you groovy excel ppl out there. I need a quick answer to the best way to calculate % increase and decrease in Excel?

asked Jan 10 '12 at 12:45

ShockerSH's gravatar image

ShockerSH
1.3k11125


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.

link

answered Jan 10 '12 at 13:34

Steve's gravatar image

Steve
2.3k163055

edited Jan 19 '12 at 14:16

1

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

(Jan 16 '12 at 16:26) Simon H Simon%20H's gravatar image

Nice catch @simon H - My bad!

Thanks for catching that!

(Jan 19 '12 at 14:17) Steve Steve's gravatar image

bingo - thnx

(Jan 20 '12 at 16:10) ShockerSH ShockerSH's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      `code`
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×17
×7

Asked: Jan 10 '12 at 12:45

Seen: 49,090 times

Last updated: Jan 20 '12 at 16:10

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact