Use an if function in cell h18 to calculate the commission, Ask an Expert

Management Studies

Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91509238

Have any Question?Write your Review or question?

Related Questions in Operation Management

Scenario you are working for a major us corporation that

Scenario You are working for a major U.S. corporation that wants to expand its reach globally and has narrowed the search down to either Mexico or Japan. Your supervisor has asked you to analyzes potential compliance iss ...

1 choose criteria for a checklist to identify the quality

1. Choose criteria for a checklist to identify the quality problems (possible defect issues) for manufacturing shirts and blouses. 2. Prepare a fish-bone chart explaining how a pizza delivery can arrive late on a Friday ...

In 2013 it was revealed that the internal revenue service

In 2013 it was revealed that the Internal Revenue Service had singled out conservative groups for special targeting since before 2010. More specifically, when groups with conservative sounding names, such as “Patriot” an ...

1 think about a healthcare organization discuss the three

1. Think about a healthcare organization. Discuss the three biggest factors that may restrain or resist change. What would have to change in the culture of the organization in order to get past these factors, and why? 2. ...

Business lawfor years courts employers and employees have

Business Law: For years, courts, employers, and employees have struggled with the issue of employee drug testing. Employers want their employees to be drug free, whereas employees do not want to submit to an invasive and ...

Is the geographic location of a private sector companys

Is the geographic location of a private sector company's operations a mandatory subject of bargaining under the NLRB? Should it be? If a company determines to establish a production operating facility in another geograph ...

1 explain the difference between a firms corporate strategy

1. Explain the difference between a firm's corporate strategy and business strategy? Why do firms need to look at both aspects. 2. How can virtual teams work well together when the team members are spread far apart? 3. I ...

Complete part 2 of the business plan to includemarket

Complete part 2 of the business plan to include Market Opportunity 1. What is the expected size and growth rate of your market? 2. What is your fundamental marketing strategy? Cost leadership. Differentiation. Focus. 3. ...

1 managerial economics is concerned with the application of

1. Managerial Economics is concerned with the application of economic principles and methodologies to the decision making process within the firm or organization. Clearly explain the six (6) steps proposed by Samuelson a ...

Jim is a disabled veteran because of his disability jim can

Jim is a disabled veteran. Because of his disability, Jim can only work part time. He collects government disability to help finance his monthly home mortgage payments and ordinary living expenses. Jim lives in a modest ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert