# Percentage Difference Between Two Values

Sep 15, 2009I am trying to create a formula that can work out the % difference between two values. The formula I am using is:

=(B1-A1)/ABS(A1)

So, where

A1=1, B1=2, = 100%

A1=-1, B1=2, = 300%

This seems to work perfectly, apart from where there are zero numbers involved. The answers I want to have are as follows:

A1=0, B1=0, = 0%

A1=0, B1=-1, = -100%

A1=0, B1=1, = 100%

A1=-1, B1=0, = 100%

A1=1, B1=0, = -100%