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 down, it returns negative percent change when some of them should be positive. I cannot use the ABS() function with all of them because some of them really are negative changes. Is there a way to not have to correct them manually?
