A B D E F G H 1 J Apply the if and nested if formula for calculating bonuses of each sales Person in the yellow highlighted cells according to the bonus criteria given below. 1st-Bonus Amount 2nd-Bonus Amount 3rd-Bonus 4th-Bonus Total Amount Amount Bonus No. 1 Sales 400,500 372,977 282.984 403,096 389.666 137,554 1,986,777 1 Sales Person 2 Naveed 3 Nasir 4 Zubair 5 Zafar 6 Sabir 7 Farooq 8 9 Bonus Criteria: 10 Bonus-1: 11 Bonus-2 12 Bonus-3 13 14 15 Bonus-4 16 17 Bonus is 3% of Sales made by Team is greater than 100,000 otherwise 0 Bonus is 5% of Sales if sale is Greater than 200,000; Otherwise 0 Bonus is 5% if Sales is Greater than 400,000; Bonus is 3% if Sales is Greater than 300,000 & less than 400,000 Bonus is 2% if Sales is less than 300,000 Bonus is 5% if Sales is Greater than 400,000; Bonus is 3% if Sales is Greater than 300,000 & less than 400,000 Bonus is 2% if Sales is greater than 200,000 & less than 300,000 No Bonus below sales of 200,000 18 19 20 Q1 Q2 (+ Ready + 9098