Forum Discussion
Percent Change with Mix of Negative and Positive Numbers
This is a pretty simple one -- I am trying to calculate the percent change between Column B and Column C. My problem is that there is a mix of positive and negative numbers so when I copy the formula...
Ideally, it would be the percent increase(or decrease) of Given Year (Column B) over the 3 Year Average (Column C)
Try this:
=(B2-C2)/ABS(C2)
Format the cell with the formula as a percentage, then fill down.
