What is the correct precentage difference
 

This is perhaps a mathematical question I am querying. If AU42 = 3 and AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

Iguess it depends on the comparison basis:

If you trying you determine how much higher is 7 than 3, then I'd say
=AR42/AU42-1
If how much lower is 3 than 7, then viceversa =-(AU42/AR42-1)

Regards,
KL

"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3 and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

I may be wrong but I think that the question is ambiguous.
Can you say what numerical value you would want returned given the two
numbers in your example?

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3 and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

% 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

The percentage returned should be approx. 133.333333%

The formula =AU42/AR42*100/100
returns 233%

"Jack Sheet" wrote in message
...
I may be wrong but I think that the question is ambiguous.
Can you say what numerical value you would want returned given the two
numbers in your example?

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3 and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

Then u can use the first of the two I suggested above.

KL

"Pat" wrote in message
...
The percentage returned should be approx. 133.333333%

The formula =AU42/AR42*100/100
returns 233%

"Jack Sheet" wrote in message
...
I may be wrong but I think that the question is ambiguous.
Can you say what numerical value you would want returned given the two
numbers in your example?

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3 and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

In that case
=(AR42-AU42)/AU42
returns 1.3333 etc
If you want that displayed as a % it is probably best to number-format the
cell as a percentage, and it will then be displayed as
133.333%

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
The percentage returned should be approx. 133.333333%

The formula =AU42/AR42*100/100
returns 233%

"Jack Sheet" wrote in message
...
I may be wrong but I think that the question is ambiguous.
Can you say what numerical value you would want returned given the two
numbers in your example?

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3 and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat

Just a (slightly) more efficient formula:

=AR42/AU42 - 1

as below, formatted as a percentage.

In article ,
"Jack Sheet" wrote:

In that case
=(AR42-AU42)/AU42
returns 1.3333 etc
If you want that displayed as a % it is probably best to number-format the
cell as a percentage, and it will then be displayed as
133.333%

Thanks fellas that solved it.
Pat

"Jack Sheet" wrote in message
...
In that case
=(AR42-AU42)/AU42
returns 1.3333 etc
If you want that displayed as a % it is probably best to number-format the
cell as a percentage, and it will then be displayed as
133.333%

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
The percentage returned should be approx. 133.333333%

The formula =AU42/AR42*100/100
returns 233%

"Jack Sheet" wrote in message
...
I may be wrong but I think that the question is ambiguous.
Can you say what numerical value you would want returned given the two
numbers in your example?

--
Return email address is not as DEEP as it appears
"Pat" wrote in message
...
This is perhaps a mathematical question I am querying. If AU42 = 3
and
AR42
= 7 what is the percentage difference of the two.

=AU42/AR42*100/100

This is my best shot at it.

regards
Pat