I am trying to calculate the percent change between two values.
However in cases where the value = 0 I am getting the divide by zero error.
For example in Cell A1 I have the first value and B1 the second value. In Cell C1 I type the formula: =(B1-A1)/ABS(A1) to get the percentage change. Any ideas on how I can fix this? Thanks.