In cell C4, enter a formula using a nested IF function to determine the amount of the monthly bonus * If the monthly sales are greater than $1,500,000 there is 4% bonus * If the monthly sales are greater than $1,000,000, there is a 3% bonus * If the monthly sales are greater than $500,000, there is a 2% bonus b). In cell H4, use a COUNTIF function to calculate the number of months that had a bonus of more than $20,000 c). In cell H5, use the AVERAGEIF function to determine the average bonus amount for bonus' greater than $20,000.

C4 9 A B D E F G H I Fit Forever Exercise Equipment - Monthly Sales 1 Bonus Months > $20,000: Average Bonus > $20,000: 2 3 Month Monthly Sales Bonus 4 2018-01-31 $623,864.00 5 2018-02-28 $471,085.00 6 2018-03-31 $633,232.00 7 2018-04-30 $844,761.00 8 2018-05-31 $871,939.00 9 2018-06-30 $1,164,621.00 10 2018-07-31 $1,021,559.00