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...
Try this:
=(B2-C2)/ABS(C2)
Format the cell with the formula as a percentage, then fill down.
