subject
Business, 14.03.2022 03:40 issaaamiaaa15

9. In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 15:00
Abroker showed one of his own listings to a buyer he was representing. the buyer decided to make an offer on the property, which was accepted. at no point did the broker disclose his dual agency status. the broker may be:
Answers: 3
question
Business, 21.06.2019 20:50
Your goal is to have $2,000,000. you have a total of $40,000 today. you invest the $40,000 and want to add to it each month. at 10% annual interest, how much do you need to invest each month in order to bring the total up to $2,000,000 30 years from now?
Answers: 2
question
Business, 22.06.2019 11:10
Use the following account numbers and corresponding account titles to answer the following question. account no. account title (1) cash (2) merchandise inventory (3) cost of goods sold (4) transportation-out (5) dividends (6) common stock (7) selling expense (8) loss on the sale of land (9) sales which accounts would appear on the income statement?
Answers: 3
question
Business, 22.06.2019 11:30
When the amount for land is 36,000 and the amount paid for expenses is 10,000, the balance of total asset is
Answers: 2
You know the right answer?
9. In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (...
Questions
question
Mathematics, 11.09.2020 02:01
question
Social Studies, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Biology, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Social Studies, 11.09.2020 02:01
question
English, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
English, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
English, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
question
Mathematics, 11.09.2020 02:01
Questions on the website: 13722360