Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commission is 26% of the sales. If the company earns less than $275,000 in a month, the commission is 17% of the sales. Calculate the commissions as follows: a. b. C. d. In cell B16, enter a formula that uses the IF function and tests whether the total sales for July (cell B9) is greater than or equal to 275000. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%. Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 to calculate the commissions for August through December.
Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commission is 26% of the sales. If the company earns less than $275,000 in a month, the commission is 17% of the sales. Calculate the commissions as follows: a. b. C. d. In cell B16, enter a formula that uses the IF function and tests whether the total sales for July (cell B9) is greater than or equal to 275000. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%. Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 to calculate the commissions for August through December.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 2R
Related questions
Question
I need help with questions 9 given for Excel.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning