Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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!!!

Check out our Excel Resources

Re: How do I calculate an attrition rate?

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

Re: How do I calculate an attrition rate?

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.