"getravel" wrote in message
...
"Jon Peltier" wrote:
"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.

You just need to divide urgent requests by total requests, and format as
a
percentage.

Jon,

thanks for taking the time to reply back. Please allow me to clarify my
question.

I know which figures to use to get the percentage, but what I'm looking
for
is a formula that will do this for me - divide one cell (Urgent requests)
by
the other (Total requests). I can manually figure out the percentage, but
the values in these two cells will increase on a daily basis. I'd rather
let
the formula figure out the percentage.

Do you know if there is such a formula?

Thanks again for taking the time to write.

The formula is simply =(Urgent requests)/(Total requests)

For (Urgent requests) put the reference of the cell which has your number of
urgent requests, and for (Total requests) put the reference of the cell
which has your number of total requests.
--
David Biddulph