MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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