Computers and Technology, 02.11.2020 17:20 josephraven778
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: 1
Computers and Technology, 24.06.2019 18:00
Hacer un algoritmo que me permita ingresar el nombre de una parcela de terreno y muestre junto al mensaje “tipo de suelos: suelos fumíferos, ¡excelente!
Answers: 1
Computers and Technology, 24.06.2019 18:30
Is a type of bullying that takes place when a person intentionally posts negative information about another person that is not true.
Answers: 2
Computers and Technology, 25.06.2019 07:00
Asap 50 points ( paragraph pls) discuss the role of the concept behind the "internet of things (iot)" in today's digitally connected society.
Answers: 2
Computers and Technology, 25.06.2019 08:00
When date is processed into a meaningful form, i becomes
Answers: 1
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Social Studies, 27.06.2019 18:30
English, 27.06.2019 18:30
Mathematics, 27.06.2019 18:30
Biology, 27.06.2019 18:30
History, 27.06.2019 18:30
Computers and Technology, 27.06.2019 18:30