Forum Discussion
chrisellerby
May 02, 2023Copper Contributor
Creating variable percentages for a bonus spreadsheet
Hello!
I am hoping someone can help - I am looking at putting together a bonus spreadsheet for the guys who work for me but I need the formula to give different percentages as their bonus percent gets bigger the higher their revenue
for example
£0 - £4033 - 0%
£4034 - £10,000 - 20%
£10,001 - £20,000 - 22%
£20,001 + 25%
Basically if the revenue hits £11,000 it should automatically show the breakdown of what is earned to 20% then what is earned at 22%
Thank you in advance
See the attached workbook. It demonstrates both a single formula to calculate the total bonus and separate formulas to calculate the tiers, using a lookup table.
See the attached workbook. It demonstrates both a single formula to calculate the total bonus and separate formulas to calculate the tiers, using a lookup table.
- chrisellerbyCopper Contributor
Thanks HansVogelaar