subject

Lindsey also needs to calculate 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%.
c. If the condition is false, multiply the total sales for January (cell B10) by 0.27 to calculate a commission of 27%.
d. Use the Fill Handle to fill the range C17:G17 with the formula in cell B17 to calculate the commissions for February through June.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:00
Why the bear has a slunky tail determine the meaning of the word slunk in the story
Answers: 1
question
Computers and Technology, 23.06.2019 22:40
22. sata3 allows for data transfer rates of 600 mb/s. explain why you would likely not be able to copy data from one hard drive to another at anywhere close to this speed. also, what could be upgraded on the computer to achieve transfer speeds closer to 600 mb/s
Answers: 1
question
Computers and Technology, 24.06.2019 01:30
How can you make your column headings stand out?
Answers: 1
question
Computers and Technology, 25.06.2019 09:20
Problem 3: (hand) write the member function implementations for the class hand, which simulates a hand of 2 cards, into the file hand.cpp. the relative strength of 2 hands are determined by the following rules: • a pair (two cards of the same number) is the strongest hand. • two cards of the same suit is the next strongest hand. • two cards of different numbers and suits is the weakest hand. • within the same kind of hands, the stronger hand is determined by the larger number. • if two hands are of the same kind and the larger numbers are the same, the stronger hand is given by the hand whose smaller number is larger. • if all above fails, the two hands are of equal strength. i.e., all suits are of equal strength. • 2 is the weakest number. an ace is stronger than a king. you are using a single deck of cards. so a hand of a♥a♥ is impossible. here are some examples:
Answers: 3
You know the right answer?
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Questions
question
Mathematics, 25.09.2019 05:30