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

Show answers

Answers

Answer from: electrofy456

Enter this and you’ll be good to go!

Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or

Answer from: 335716hdjsngrhrs

I have created and attached an image with example values for this question.

First we'll learn the IF function syntax:

IF(logical_test, value_if_true, [value_if_false])

Where

logical_test is the decision making comparison

value_if_true is the result to return when TRUE

value_if_false is the result to return when FALSE

We assume that cells B10 to G10 contain the Total Sales for January to June. And cells B17 to G17 contain the Commissions for January to June.

The formula to use in cell B17 is:

=IF(B10>=200000;True;False)

The formula to use in cell B17 is:

=IF(B10>=200000;B10*0.35;False)

The formula to use in cell B17 is:

=IF(B10>=200000;B10*0.35;B10*0.27)

To copy the formula in B17 to C17:G17, you can just copy and paste or select cell B17 and drag from the black square on the bottom right of the cell.

Answer from: Quest

answer: when the substance contain the two parts (polar and non-polar) like soap.

explanation:

soap is produced from the basic hydrolysis of ester "saponification", it is considered as a salt of hydrocarbons. the soap molecule contains the two parts: a polar group (-coo-na+) and a non-polar group (r-hydrocarbon part). the polar group is called the head and the tail is the non-polar group. the polar group is hydrophilic in nature (water loving) and the non-polar group is hydrophobic in nature (water repelling).the polar/non-polar nature of a substance is useful that it can dissolve the non-polar substances by the polar part and also can dissolve the polar substances by the non-polar part. it commonly used in detergents and soaps.

Answer from: Quest

your game would probably crash if its too much lag but other players will also ! xd

hope this ! xd

also, can i get brainliest ?

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 02:00, deeknuk

What is the main benefit of minimizing the ribbon in word? more options will be accessible through customized keystrokes. more of the document will be viewable without needing to scroll. fewer controls will be accessible to the user by using the mouse. fewer editing options will be available without entering a password.

Answers: 1

continue

Computers and Technology, 23.06.2019 16:30, rileysndr1782

Monica and her team have implemented is successfully in an organization. what factor leads to successful is implementation? good between different departments in an organization leads to successful is implementation.

Answers: 1

continue

Computers and Technology, 24.06.2019 07:00, AnaiyaKirksey8

You are most likely to automatically encode information about

Answers: 1

continue

Computers and Technology, 24.06.2019 13:30, nina288

What process should be followed while giving a reference? sam has given a reference of his previous manager in his resume. sam should him in advance that the potential employers will him.

Answers: 1

continue

You know the right answer?

Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...