Lindsey also needs to calcite 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%.

Question

07-05-2021
Computers and Technology

Answered

Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently.

Lindsey also needs to calcite 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%.

Sagot :

Thank you for visiting our platform. We hope you found the answers you were looking for. Come back anytime you need more information. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Discover more at Westonci.ca. Return for the latest expert answers and updates on various topics.

Which statement best describes the impact of President Carter's policies for increasing economic growth in America?A. They had no impact.B. They had a slight im

If point [tex]$ P $[/tex] is [tex]$\frac{9}{11}$[/tex] of the distance from [tex]$ M $[/tex] to [tex]$ N $[/tex], what ratio does point [tex]$ P $[/te

The functions [tex]f[/tex] and [tex]g[/tex] are defined as follows:[tex] f(x) = -4x + 4 \\ g(x) = -2x^3 - 3 [/tex]Find [tex]f(3)[/tex] and [tex]g(-4)[/tex]. Sim

What is the first step to solve the following system of equations using substitution? [tex]\left\{\begin{array}{l}x-y=-1 \\ 2x-y=3\end{array}\right.[/tex]A. Mul

Look at the table below. Rewrite the mass for the third object in scientific notation.\begin{tabular}{|l|l|}\hline Object & Mass (g) \\\hline 1 & 0.0012

Part CTo rewrite [tex] y(t) = 2 \sin 4 \pi t + 5 \cos 4 \pi t [/tex] in the form [tex] y(t) = A \sin (\omega t + \phi) [/tex], solve for [tex] \phi [/tex].Show

This chart shows descriptions of the atoms for four different substances.\begin{tabular}{|c|c|c|c|}\hlineObject 1 & Object 2 & Object 3 & Object 4 \

what effect do foods with a high glycemic se mic index have on the body

Which is a true statement comparing the graphs of [tex]\frac{x^2}{6^2} - \frac{y^2}{8^2} = 1[/tex] and [tex]\frac{x^2}{8^2} - \frac{y^2}{6^2} = 1[/tex]?A. The f

The following information applies to the questions displayed below.Cane Company manufactures two products called Alpha and Beta that sell for [tex]\$ 125[/tex]