You just need to divide urgent requests by total requests, and format as a
percentage.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"getravel" wrote in message
...
I've created a column chart showing 2 quarterly totals - (1) Total
requests
and (2) Urgent requests. I need a formula that will calculate the
percentage
of Urgent requests in relation to the number of total requests.
I checked the two (PERCENTRANK and PERCENTILE) that I found in the Insert
Function dialog, but neither of these provided the percentage that I'm
looking for.
Any informtion you can provide would be greatly appreciate.
--
Thanks,
getravel