Answered

Looking for reliable answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Get quick and reliable solutions to your questions from knowledgeable professionals on our comprehensive Q&A platform. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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%.

Sagot :

Answer:

srry dont know

Explanation:

We appreciate your visit. Our platform is always here to offer accurate and reliable answers. Return anytime. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.