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