# Solved: Help with a calculation

Discussion in 'Business Applications' started by abbyt1904, Apr 28, 2015.

Not open for further replies.

Joined:
Jul 15, 2009
Messages:
29
Hi

I am a maths idiot and I need help with working out a formula? I know what I want to do (I think) but need to know how to get there.

Attached is my Excel sheet.
I am looking for a result to populate in F9 which will either use the figure in F7 or F8

If an employee is more engaged, you could save 87% of the cost of replacing them.
If the cost of replacing them is £39750.00
How much could you save per 1% of increased engagement

There is a sliding scale...and I dont want users of my calculation to need to know their engagement score.

Not even sure if this is possible..

Thanks

File size:
9.3 KB
Views:
14
2. ### Zack Barresse

Joined:
Jul 25, 2004
Messages:
5,452
Hi there,

Sounds like homework... which is typically frowned upon if you're asking for someone to do it for you online, since that's cheating. And nobody likes a cheater.

If it's not for homework (the onus is on you to prove that to us) please explain a bit more about your variables and the calculation you're looking for. It looks like you have two variables: 1) employee annual wage, and 2) employee engagement percent. You also don't define what the turnover rate should be. While yes there is a sliding scale, you don't define what it is or how it should be calculated (i.e. linear, logarithmic, etc.).

Joined:
Jul 15, 2009
Messages:
29
Ha, thanks. No, it's not homework. If I was still studying I'd be in a lot of trouble!!!

A colleague has gone off sick, had this engagement model dumped on me. Let me look at your points and see if I can work out what you mean....

As Seen On