Get UNSTUCK with Expert Advice

QUESTION

I need to calculate percent increase/decrease. Ex. 1 Base for year one is 345 (cell A1) the next year was 250 (cell A2). I use A1-A2/A1 and get 27.54% but it should show a negative. Ex. 2 Base year of 345(cell A1) for one year and the next year 485 (cell A2). I use A1-A2/A1 and get -40.58%, but it should be positive increase. What do I need to do to reflect a negative or positive result?

ANSWER

Try entering the following formula instead of the formula you use

=-(1-A2/A1)

Note that there is a minus sign right after the '=', this is not a mistake so don't leave it out.

 

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us