• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

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.
0
fjkaykr11
Asked:
fjkaykr11
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
To determine the percentage change from A1 to B1:

   =IFERROR((B1-A1)/ABS(A1),0)

Kevin
0
 
fjkaykr11Author Commented:
thanks
0

Featured Post

Hire Technology Freelancers with Gigs

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now