| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I need a formula that will calculate the ratio of number of applicant versus
number of interview....any suggestions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
Number of interviews / number of applicants
-- Brevity is the soul of wit. "susan8541" wrote: I need a formula that will calculate the ratio of number of applicant versus number of interview....any suggestions |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
great-hopefully this is what she wants! Thanks for the reply.
"Pete_UK" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
thank you, this is better.
"Gord Dibben" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
