View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
NBVC[_156_] NBVC[_156_] is offline
external usenet poster
 
Posts: 1
Default Formula for Relative Percent Difference...


JIn an empty cell, just replace the a and b with the actual cell
references..and place an = sign in front.

e.g

=(A2-B2)/((A2+B2)/2)*100

where cell A2 contains your a data point and cell B2 contains your b
data point.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125550