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]
2 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]2 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
Match the definition with the term.
RSB [31]

Answer:

a. It is a collection of all accounts with their activity and balances that exist in a business.  - A general ledger

The General Ledger is the central record in an accounting system and contains a record of all financial transactions in the company.

b. It is a book of original entry that includes a chronological record of all transactions that Have occurred within a business during a period occurred. - A Journal

When a transaction takes place in a business, it is recorded first in a Journal. As such, a journal contains a chronological record of all transactions that have occurred within a business during a period occurred.

c. It is a list of each account and its balance at any given time and is used to verify that debits = credits . - Trial Balance

The Trial Balance helps a business balance its debits and credits by listing them so then equating them to verify that indeed the debits match the credits.

d. It is a list of all ledger accounts which exist in a business and includes an identification number assigned to each account . - A chart of accounts

3 0
3 years ago
An investment adviser representative who prepares financial plans for customers is also a registered life insurance agent in tha
Alex777 [14]

Answer:

D. Recommendation to buy life insurance does not make the investment advice any less objective.

Explanation:

investment adviser representative are also regarded as financial planner are advisers that gives advice in term of financial service to firms or individual or his/ her customer

In the situation described in the question whereby, the agent recommends that a customer sell a mutual fund holding and use the proceeds to buy life insurance, then these information are needed to be disclosed to the customer

✓. Sale of the mutual fund mayor is alt in a taxable event to the customer

✓Recommendation to purchase life insurance is in no way connected to the services offered by the advisory firm

✓Agent will earn a commission on the life insurance purchased by the customer

6 0
3 years ago
What is the repitition of the elements of art?​
torisob [31]

Answer:

Repeating of elements in a design.

Explanation:

Repetition is defined as repeating a single element several times in a design. In arts, repeat patterns are used by the artists. Repeat Pattern is the repetition of lines, shapes, colors, textures and forms. Artists and designers used patterns to discover their decorative style, to understand their structural form and to communicate their intrinsic beauty so for these reasons repetition is used.

7 0
3 years ago
Define foreclosure economics.​
Kobotan [32]

Answer:

Foreclosure is the legal process by which a lender attempts to recover the amount owed on a defaulted loan by taking ownership of and selling the mortgaged property

8 0
2 years ago
Which two advantages do home buyers have over renters?
Snowcat [4.5K]
Answers A and E seem correct. B makes no sense. C makes no sense. and my renters insurance was very cheap vs property insurance.
5 0
3 years ago
Read 2 more answers
Other questions:
  • What is the main purpose of a sprint review?
    14·1 answer
  • Paul splits an investment of $20000 , a portion earning simple interest at a rate of 3.8 % per year and the rest earning at a ra
    12·1 answer
  • Brief exercise 1-9 at the beginning of the year, morales company had total assets of $816,000 and total liabilities of $526,000.
    7·1 answer
  • 12 less than the quantity of a number and 7 is -2
    9·1 answer
  • Redding Corp. reported the following information in its 2017 annual report (in millions). Plans' assets at fair value, January 1
    13·1 answer
  • Orlando has a bank statement balance of $414.25 and $5.90 service charge. His check register shows $374.16 and he has two outsta
    11·1 answer
  • Suppose People's bank offers to lend you $10,000 for 1 year on a loan contract that calls for you to make interest payments of $
    12·1 answer
  • magine that the current owner of the land in the previous exercise was willing to sell the land for $2 million. Assuming this am
    8·1 answer
  • The method of cost estimating that falls between the other two cost estimating methods in complexity is the __________ method.
    14·1 answer
  • Classify the items as to whether or not they would be included in calculating the GDP for Canada. If a country is not specified,
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!