Remember Me?

 bnorris external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 1 Formula for Relative Percent Difference...

I'm trying to develop a data control chart and I can't find the function for
relative percent difference...I think it might be a nested function that I
need to use? I'm new to this aspect of excel so, please be kind. I have
found the formula
ABS (A-B)/A but I need a function for relative percent difference....how can
I chage the following formula into something that works in excel?

(a-b)/((a+b)/2)*100 = relative percent difference, where a is a data point
in colum A and b is a data point in colum B?

Thanks

 NBVC[_156_] external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 1 Formula for Relative Percent Difference...

JIn an empty cell, just replace the a and b with the actual cell

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

 joeu2004 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 2,059 Formula for Relative Percent Difference...

"bnorris" wrote:
(a-b)/((a+b)/2)*100 = relative percent difference

No. I believe RPD is: abs(a-b) / ( (a+b)/2 ) * 100. See
http://en.wikipedia.org/wiki/Percent_difference .

In Excel, that can be written:

=ABS(A1-B1) / AVERAGE(A1,B1)

formatted as Percentage. Alternatively:

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

again formatted as Percentage.

----- original message -----

"bnorris" wrote in message
...
I'm trying to develop a data control chart and I can't find the function
for
relative percent difference...I think it might be a nested function that I
need to use? I'm new to this aspect of excel so, please be kind. I have
found the formula
ABS (A-B)/A but I need a function for relative percent difference....how
can
I chage the following formula into something that works in excel?

(a-b)/((a+b)/2)*100 = relative percent difference, where a is a data
point
in colum A and b is a data point in colum B?

Thanks

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Heather Excel Worksheet Functions 3 May 2nd 08 01:24 AM [email protected] Excel Discussion (Misc queries) 1 August 9th 07 05:42 AM [email protected] Excel Discussion (Misc queries) 2 August 9th 07 05:16 AM what is difference between absolute addr Excel Discussion (Misc queries) 1 July 22nd 06 08:17 AM David Iacoponi Excel Discussion (Misc queries) 2 September 15th 05 06:35 PM

All times are GMT +1. The time now is 10:23 PM. Copyright ©2004-2019 ExcelBanter.