141k views
1 vote
Lindsey also needs to calcite the commissions earned each month. If the company earns $200,000 or more in a month, the commission is 35% of the sales. If the company earns less than $200,000 in a month, the commission is 27% of the sales. Calculate the commissions as follows:

a. In cell b17, enter a formula that uses the IF function and tests whether the total sales for January ( cell B10) is greater than or equal to 200000
b. If the condition is true, multiply the total sales for January ( cell B10) BY 0.35 TO calculate a commission of 35%.

1 Answer

4 votes

Answer:

srry dont know

Step-by-step explanation:

User Adid
by
4.5k points