1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lelechka [254]
3 years ago
14

9. Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commissio

n 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%.
Business
1 answer:
nadezda [96]3 years ago
5 0

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

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

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

  • 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 <em>=IF(B9>=275000, B9*0.26, B9*0.17)</em>

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

You might be interested in
Create a conversational but professional tone in letters, e-mail messages, instant messages, and memos by Group of answer choice
egoroff_w [7]

Answer:

Using familiar words, occasional contractions, and pronouns such as you and I.

Explanation:

This is the best strategy in order to create a conversational but professional tone in letters, e-mail messages, instant messages and memos. This strategy suggests the use of familiar words. This will give a personal, relaxed tone to your texts. Moreover, it suggests the use of occasional contractions. Contractions are useful when it comes to making a text less formal and more intimate. Finally, using pronouns such as "you" and "I" gives a tone of closeness, while remaining professional.

4 0
3 years ago
What is a sercured loan
VARVARA [1.3K]

Answer:

Secured loan is as below

Explanation:

A secured loan is money that you borrow by offering an asset as collateral. The lender will hold on the asset until the full loan amount is paid back. A secured loan is a good option when borrowing a large amount of money.  It attracts low-interest rates.

Lenders consider secured loans less risky because the customer provides a valuable asset as a back-up should they fail to repay. Homes and land are the most common properties used as collateral for secured loans.

6 0
3 years ago
In most cases, whether the contract has not yet been performed (an executory contract) or has been fully performed (an executed
Jlenok [28]

Answer: disaffirm

Explanation:

most cases, whether the contract has not yet been performed (an executory contract) or has been fully performed (an executed contract), the minor may disaffirm the contract.

It should be noted that a contract that is signed by a minor unless in some rare exceptions is normally void and therefore, the minor can disaffirm the contract.

8 0
4 years ago
If job a and job b are identical in all aspects, except that job b pays higher wages, what will happen over time?
Bumek [7]
Job b will go out of business sooner if their profit is the same as A
6 0
3 years ago
Excerpts from Dowling Company's December 31, 2018 and 2017, financial statements and key ratios are presented below (all numbers
Rus_ich [418]

Answer:

Option (A) is correct.

Explanation:

Given that,

2018:

Accounts receivable (net) = $20

Net sales = $115

Cost of goods sold = $60

Net income = $20

Inventory turnover = 5.22

Return on equity = Return on assets × Equity multiple

                             = 10.3% × 2.36

                             = 24.308% or 24.3%

Therefore, Dowling's return on equity for 2018 is 24.3%.

5 0
4 years ago
Other questions:
  • _____________ is the new-product development phase where hope springs decides that the flavor additive has enough market interes
    10·1 answer
  • The consumer price index for Planet Econ consists of only two items: books andhamburgers. In 2010, the base year, the typical co
    15·1 answer
  • Suppose that an installment plan calls for five payments to be made. The total paid in this plan is 20% more than the price woul
    10·1 answer
  • Which of the following would NOT be an operations function in a commercial bank? Group of answer choices
    12·2 answers
  • The debits and credits for four related entries for a sale of $15,000, terms 1/10, n/30, are presented in the following T accoun
    14·1 answer
  • This individual worked to determine a "fair day’s work," or what an average worker could produce at a reasonable pace. This indi
    8·2 answers
  • The consumption function will shift down if:
    7·1 answer
  • Would a firm with low degree of operating leverage need to sell more units of products to reach break-even point or less? Why?
    5·1 answer
  • A trademark is an exclusive right granted to its owner to publish and sell a musical, literary, or artistic work during the life
    7·1 answer
  • vasily is a manager at a large snack foods company. vasily believes his company would benefit from being larger and thinks the s
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!