How do you convert a ratio to a percentage?

[Cheri315]

I posted this under percent to ratio but didn't realize the thread was a year old.

I have the opposite question. How do you convert a ratio to a percentage.

Say I hired 41 people and had to terminate 25. What is the turnover ratio percentage. I used =SUBSTITUTE(TEXT(41/25,"?/?"),"/",":") which got me a 5:3 ratio but I guess I'm looking for a percentage of turnover.

Last quarter it was hire 27 and termed 20 and they came up with 17% I've done everything possible to figure out how they calculated that but it's more like 68%. If you only retained 7 of the 27 you hired it seems it would have to be a much higher percentage.

Can anyone help?

 

[marstonk]

what is the total number of staff as i think you may need that if you have the movement hired less terminated / total number of staff this will give you your turnover in % I beleive.

kitty

 

[fairwinds]

Hi,

How about:

=1/TEXT(41/25,"0.000") and format cell as %

 

[Cheri315]

Thanks for the replies. At least I think I was on the right track.

That's is more in line with what I thought it should be - it came out to be 61%. I still don't know how they got a 17% turnover when they hired 27 and lost 20. The total number of employees averages around 140. I questioned whether that should be in the equation too.

If I use the above in the formula the percentage ratio is 74% not 17%.[/img]

 

[Marc]

turnover rate - the ratio of the number of workers that had to be replaced in a given time period to the average number of workers.

TOR=(num. who left/avg. num. of emps.)*100

=(25/140)*100

=17%

 

[Cheri315]

So the number of hires doesn't enter into the equation. Well at least you got me to 17%. Thanks so much.