Bonus calculator

Need an employee facing spreadsheet to calulate a bonus. They input their actual results, it tells them what Tier they qualify for, applies a % factor against their sales for hitting each level and a multiplier % if they hit at least 3 of the 4 individual tiers. There is a simalar system for Team Results.

There is one additional project to help with later, updating our Office Sales Tracker.