Question: In cell B 1 7 , enter a formula that uses the IF function and tests whether the total sales for January ( cell B

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.
If the condition is true, multiply the total sales for January (cell B10) by 0.35 to calculate a dividend of 35%.
In cell B17, enter a formula that uses the IF function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

please walk me through steps 8-13 8. Lindsey wants to determine how the sales of each month contributed to the total sales. Calculate this information for her as follows: a. In cell B13, insert a...

Q:

HELP! what do i type in the excel formula to do what the instructions are asking for 8. a. c. 9. Lindsey wants to determine how the sales of each month contributed to the total sales. Calculate this...

Q:

Lindsey wants to determine how the sales of each month contributed to the total sales. Calculate this information for her as follows: a . In cell B 1 3 , insert a formula without using a function...

Q:

Alexi also needs to calculate the dividends earned each month. If the company earns $ 2 0 0 , 0 0 0 or more in a month, the dividend is 3 0 % of the sales. It the company earns less than $ 2 0 0 , 0...

Q:

9 . Amir also needs to calculate the commissions paid each month. If the company earns $ 2 7 5 , 0 0 0 or more in a month, the commission is 2 6 % of the sales. If the company earns less than $ 2 7 5...

Q:

a . In cell B 1 6 , enter a formula that uses the IF function and tests whether the total sales for July ( cell B 9 ) is greater than or equal to 2 7 5 0 0 0 .

Q:

Emma Scott is a direct sales representative for ExpressBuy, an online marketplace for consumer products, headquartered in Rustenburg, North West. She has created a worksheet comparing the profits of...

Q:

10 6. 4. 5. 7. PROJECT STEPS Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around...

Q:

Please provide the steps for how to do each step, not just the final answer. 13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role....

Q:

1 3 . Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows: a ....

Q:

Find a condition that the vector field on R2 defined in terms of the identity chart x by f(x", x*) + f(x*, x) + f(x", a)- projects to a vector field on the Klein bottle.

Q:

The current spot rate of Canadian dollar is $0.98 and 180-day forward rate is $1.12. Interest rates of the two countries are as follows. Assume that borrowing rate and lending rate are the same each...

Q:

Strategies for Achieving Financial Stability and Strategic Growth in Higher Education In the current landscape of higher education, many institutions, including Fairleigh Dickinson University (FDU),...

Q:

Answer the following question (b) A simple U tube manometer is installed across an orifice meter. The manometer is filled with mercury (Sp.gravity 13.6) and the liquid above the mercury is carbon...

Q:

13. last word What do you think of the ethics of using unconscious nudges to alter peoples behavior? Before you answer, consider the following argument made by economists Richard Thaler and Cass...

Q:

4. Theres no such thing as bad publicity. Evaluate this statement in terms of the recognition heuristic. LO8.2

Q:

3. Economist Gerd Gigerenzer characterizes heuristics as fast and frugal ways of reaching decisions. Are there any costs to heuristics being fast and frugal? Explain and give an example of how a fast...