Suppose the sales goal for each sales rep you supervise is$200,000. If they meet this goal (i.e., the sales amount >=200000), they receive a bonus based on the total amount of sales.Suppose the sales amounts for the 10 sales rep are listed in cellsK4:K13, and you want to keep track of which sales rep met the goalby entering “Yes” for those that met the goal and “No” for thosethat did not. By using IF function, we want to place the “Yes” and“No” in the adjacent column L4:L13. Write the exact IF function youwould enter in the first cell of this column, L4.
Expert Answer
Answer to Suppose the sales goal for each sales rep you supervise is $200,000. If they meet this goal (i.e., the sales amount >= 2…