Would this be any better?

Applicants in A1............Interviews in A2

="the ratio of applicants to interviews is " &TEXT(A1/A2,"##") & ":" & "1"


Gord

On Fri, 12 Jan 2007 14:09:01 -0800, 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