Click the Sales Data by Agent worksheet and enter a nested function in cell H9 the Bonus column. If the employee is international and sold over $200,000 they receive 5% bonus, all other employees receive 3%.

2 Bonus Sales Rep 9 Ron 10 Nick 11 Sally 12 Susan 13 Bob 14 Mark 15 Swathi 16 Mike Region 3% Domestic 5% international 2015 Sales Total By Quarter Q4 Total Location Q1 Q2 Q3 Bonus 29,911.00 $92,249.00 $46, 475.00 33,947.00 $202,582.00 International 32,752.00 $30,222.00 $43,997.00 93,277.00 $200,248.00 International s 36,991.00 $54,102.00 $63,914.00 $42,642.00 $197,649.00 Domestic 50,087.00 S25, 179.00 S64,912.00 52,92300 $62,673.00 $63,635.00 57 S296 641.00 Domestic 59,678.00 $70,934.00 $78,410.00 32,994.00 $242,016.00 Domestic 66,385.00 $74,270.00 $36,165.00 76,548.00 $253,368.00 Domestic 66,936.00 S72,838.00 S60,479.00 S 63,324.00 S263,577.00 Domestic