Results 1 to 6 of 6

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

  1. #1
    New Member
    Join Date
    Jun 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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?

  2. #2
    Board Regular
    Join Date
    Jan 2003
    Posts
    273
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

  3. #3
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,638
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How do you convert a ratio to a percentage?

    Hi,

    How about:

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

  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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]

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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%

  6. #6
    New Member
    Join Date
    Jun 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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