1. Cell D4 Use The IF Function To Calculate A Bonus Only For Employees Whose Performance Rating Is Greater Than 6 The Bonus Amount Will Be 5% Of Their Annual Sales. Reference The Bonus Rate Provided In Cell F1 In Your

1. Cell D4 Use the IF function to calculate a bonus only for employees whose Performance Rating is greater than 6 The bonus amount will be 5% of their annual sales. Reference the bonus rate provided in cell F1 in your calculation. Show 0 for false results.

2. Use the Fill Handle to copy the formula from D4 to D5:D12 to calculate the bonus amount for all employees

You need to show your formular