% Difference is generally defined as:

(X1 - X2)
------------- * 100
(X1+X2) / 2


So if A1 = 3, B1 = 7 column C's % difference formula can be written as

=(A1-B1)/((A1+B1) / 2) * 100


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=320256