I think strictly speaking you want the inverse of that, i.e. the number
of applicants divided by the number of interviews - you will end up
with a number greater than (or possibly equal to) one, let's say 2.5,
so your ratio is 2.5 : 1.

Hope this helps.

Pete

susan8541 wrote:

yes, you would think it was simple. That is what I have been doing-someone
came to me and said "no, I need the ratio!" So I thought I was missing
something(?)

"Gord Dibben" wrote:

Simple arithmetic.

Number of interviews divided by number of applicants.

=50/100 would give you 50%

=25/100 would give you 25%

If I have missed this, post back or watch for other interpretations in this
thread.


Gord Dibben MS Excel MVP

On Thu, 11 Jan 2007 09:03:00 -0800, susan8541
wrote:

I need a formula that will calculate the ratio of number of applicant versus
number of interview....any suggestions