Question: 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
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%.
| Bonus | Region | ||||||
| 3% | Domestic | ||||||
| 5% | International | ||||||
| 2015 Sales Total By Quarter | |||||||
| Sales Rep | Q1 | Q2 | Q3 | Q4 | Total | Location | Bonus |
| Ron | $ 29,911.00 | $ 92,249.00 | $ 46,475.00 | $ 33,947.00 | $ 202,582.00 | International | |
| Nick | $ 32,752.00 | $ 30,222.00 | $ 43,997.00 | $ 93,277.00 | $ 200,248.00 | International | |
| Sally | $ 36,991.00 | $ 54,102.00 | $ 63,914.00 | $ 42,642.00 | $ 197,649.00 | Domestic | |
| Susan | $ 50,087.00 | $ 25,179.00 | $ 64,912.00 | $ 68,875.00 | $ 209,053.00 | Domestic | |
| Bob | $ 52,923.00 | $ 62,673.00 | $ 63,635.00 | $ 57,410.00 | $ 236,641.00 | Domestic | |
| Mark | $ 59,678.00 | $ 70,934.00 | $ 78,410.00 | $ 32,994.00 | $ 242,016.00 | Domestic | |
| Swathi | $ 66,385.00 | $ 74,270.00 | $ 36,165.00 | $ 76,548.00 | $ 253,368.00 | Domestic | |
| Mike | $ 66,936.00 | $ 72,838.00 | $ 60,479.00 | $ 63,324.00 | $ 263,577.00 | Domestic | |
| Rick | $ 74,507.00 | $ 94,178.00 | $ 41,391.00 | $ 27,235.00 | $ 237,311.00 | Domestic | |
| Rich | $ 76,889.00 | $ 49,266.00 | $ 64,225.00 | $ 55,410.00 | $ 245,790.00 | Domestic | |
| Jill | $ 90,515.00 | $ 29,238.00 | $ 30,973.00 | $ 32,145.00 | $ 182,871.00 | Domestic | |
| John | $ 97,426.00 | $ 43,061.00 | $ 26,122.00 | $ 83,391.00 | $ 250,000.00 | Domestic | |
| Greg | $ 98,094.00 | $ 47,398.00 | $ 80,755.00 | $ 40,446.00 | $ 266,693.00 | International | |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help