The Problem 2 Data worksheet contains JanuaryApril sales data for eight salespeople. If their total sales are

Question:

The Problem 2 Data worksheet contains January–April sales data for eight salespeople. If their total sales are at least $110, their bonus is 40 percent of sales; if their total sales are from $100 to $109, their bonus is 20 percent of sales. Otherwise, their bonus is 5 percent of sales. Write a LET formula to compute each person’s bonus.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: