I'm trying to get the absolute percentage correct for a formula. If there is
200 expected and 215 received I'm looking for the absolute percentage not a
percentage over 100%. The answer would always be under 100%. IWS there a
formula for this.

What's an "absolute" percentage? If you are tracking the percentage of the
expected which was received, you divide received by expected, or 215/200,
for 107.5%. It makes little sense to take a reciprocal of this, because it's
hard to care what percentage of the number of items you received was what
you had expected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"travis" wrote in message
...
I'm trying to get the absolute percentage correct for a formula. If there
is
200 expected and 215 received I'm looking for the absolute percentage not
a
percentage over 100%. The answer would always be under 100%. IWS there a
formula for this.

These entries provide examples for calculating the mean absolute percentage
error:

http://en.wikipedia.org/wiki/Calcula...ecast_Accuracy

http://en.wikipedia.org/wiki/MAPE

--
John Mansfield
http://cellmatrix.net





"travis" wrote:

I'm trying to get the absolute percentage correct for a formula. If there is
200 expected and 215 received I'm looking for the absolute percentage not a
percentage over 100%. The answer would always be under 100%. IWS there a
formula for this.