Excel 2010 Calculate Percent Increase between two values
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.