Formula / model

New Contributor

We are looking at ways to pay employees a bonus based on service, we have the maximum amount we want to pay out. What would be the best model to work out what we should pay per person? 


I have the staffs current annual salary, the days, months and years they have worked for the business. 


I need a model that can be played with, currently we are looking at depending on the category you fall in to you will get a % of you current annual salary paid but this % might change so I need a formula / model that has room for these changes. 

3 Replies

Answer deleted. I posted on the wrong question.


@Detlef Lewin can you explain what result this would give? As I got a little lost on the second part. 


Sorry, that was an answer for another question.


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies