How do I calculate an attrition rate?
Posted by Jennifer on November 20, 2001 10:12 AM
Here is what I need help on...I am calculating the attrition rate of employment.
Column B: Number of newly hired employees
Column C: Number of termed employees
Column D: Attrition rate
Calculation example:
=SUM(C6/B6)
If I have a zero in column B and C, Excel gives me
a #DIV/0 answer.
I want Excel to calculate the zero!!!
I need help...serious help...please!!!
Posted by Aladin Akyurek on November 20, 2001 10:40 AM
> Here is what I need help on...I am calculating the attrition rate of employment.
Jennifer --
I suppose you don't ask for a formula how to compute it. My Webster gives a definition (with no maths, als) that makes me believe that the formula (below) that you attempt is close home.
The following modification should give what you want:
=IF(B6,C6/B6,0)
Hope this helps.
Aladin
Posted by Jennifer on November 20, 2001 10:59 AM
Aladin,
YOUR FORMULA WORKS!!!
Thank you very much! Now they won't fire me (I will not be part of the attrition rate!). I will be sure to pose more perplexing questions in the near future.
Bye for now,
Jennifer
