Forum Discussion

chrisellerby's avatar
chrisellerby
Copper Contributor
May 02, 2023
Solved

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

Resources