Question

9. 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. 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. b. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. c. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%.

Answer 1

The required excel function which calculates the amount of commission for July is =IF(B9>=275000, B9*0.26, B9*0.17).

• The IF function in excel uses the syntax ; =IF(condition, statement 1, statement 2)

• The first argument in the function is the condition which is to check if the value in B9 is greater than or equal to 275000.

• Next argument is the statement to execute if the condition is true, which is to multiply the value in B9 by the commission percentage ; 26%

• Next argument is the statement to execute if the condition is False, which is to multiply the value in B9 by 17%.

Therefore, the required expression is =IF(B9>=275000, B9*0.26, B9*0.17)

Learn more :brainly.com/question/20620378?referrer=searchResults