Intte formula USING IF (don't use IFS] compute the Incentive rate Write the formula In cell E37 and then copy the formula own Ull E40. art (8] Second Scheme Option he incentive will be given only if the sales person has achieved the target. Also, the incentive rate is rationalized into two ckets. If the target is met and the monthly sales generated is more than or equal to $125,000 , then the incentive rate is 1.576 or e total sales of that month If the target is met and the monthly sales less than $125,000, then the incentive rate is 0.976 on the total sales of that onth i) If the target is NOT MET and the monthly sales generated is more than or equal to $125,000, then the incentive rate is 7576 on the total sales of that month If the target is NOT MET and the monthly sales generated is less than $125,000 , then no incentive will be paid rite formula USING IFS [don't use IF] compute the Incentive rate Write the formula In cell E59 and then copy the formula Own T ES2