Forum Discussion
Convert to Excel formula
Good day.
Asking for help on how to transfer this to excel formula the Employee Turnover .
Please see attached file.
thanks and advance
3 Replies
- NikolinoDEPlatinum Contributor
Here are two additional files fast from the internet...you could use as a template.
As Mr. Riny_van_Eekelen informed, several factors are needed to calculate the correct Employee Turnoverrate.Links of the inserted files
Excel Employee Turnover Cost Calculator
Standard disclaimer: there are none Microsoft sites
- Dhagz2340Copper ContributorThank you so much .. I will check
- Riny_van_EekelenPlatinum Contributor
Dhagz2340 Not sure that 10 employees, 50% resignations and $5/hr is enough to calculate the "annual cost of employee turnover". I assume that the calculator includes some assumptions on cost of recruitment, lost productivity etc.
What answers do you get when you move the slider step by step from 100% to 10%? And what happens when you leave the slider at 50% but use hourly wages from, for example, $1 to $20. Perhaps, then you can work out the underlying formula.