Weekly+Sales

This spreadsheet would be ideal for a manager to track the weekly sales of each employee and their bonus. I demonstrated how to use an if statement, max, min, and sum. I used an if statement to calculate the bonuses that salespeople would get if they exceeded $9000 in sales. All people receive a bonus at the end of the month. If you exceed $9000 or more you receive 3% bonus on sales and others receive 1%.