Thread: How do you convert a ratio to a percentage? Thanks: 0 Likes: 0

1. How do you convert a ratio to a percentage?

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?   Reply With Quote

2. Re: How do you convert a ratio to a percentage?

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  Reply With Quote

3. Re: How do you convert a ratio to a percentage?

Hi,

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

4. Re: How do you convert a ratio to a percentage?

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]  Reply With Quote

5. Re: How do you convert a ratio to a percentage?

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%  Reply With Quote

6. Re: How do you convert a ratio to a percentage?

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

User Tag List Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•