Forum Discussion
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 ...
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.
Thanks HansVogelaar