Computers and Technology, 16.10.2020 03:01 annekesimonsen
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.
Answers: 2
Computers and Technology, 22.06.2019 18:00
Determine whether the following careers would require training or college.
Answers: 1
Computers and Technology, 22.06.2019 21:50
Given int variables k and total that have already been declared, use a while loop to compute the sum of the squares of the first 50 counting numbers, and store this value in total. thus your code should put 11 + 22 + 33 + + 4949 + 50*50 into total. use no variables other than k and total.
Answers: 2
Computers and Technology, 24.06.2019 02:00
What is a loop? a. a collection of function definitions at the top of a program b. a line of code that defines a variable and assigns it a value c. a program that opens the turtle graphics window d. a block of code that repeats a specific number of times
Answers: 1
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Geography, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30
English, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30
English, 13.02.2021 04:30
Business, 13.02.2021 04:30
History, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30
Business, 13.02.2021 04:30
Mathematics, 13.02.2021 04:30