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.
LVL 3
fjkaykr11Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.