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.
