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.