VBA代写: Homework # 4

 

 

 

Homework # 4

FALL 2016

Lubin School of Business Pace University

User Defined functions for commissions

The following is the system for paying commissions in a company:

  1. Sales up to $ 15,000 the Commission is 10%
  2. Sales over $15,000 the Commission is 10% for the first $15,000 and additional 15% for any amount over $15,000 but up to $30,000.
  3. Sales over $30,000, the commission is 10% for the first $15,000, 15% for the next $15,000 and 20% for any amount over $30,000.

Code an user defined function as =CommHW(x), where x is the value of sales.  The function should be created in the worksheet LastName_FirstName-HW4.xlsm.

Examples:

  • =CommHW(15000) = 1500 (1500 = 10% of 15000)
  • =CommHW(25000) = 3000 (3000 = 10% of 15000 + 15% of 10000)

 

Results and due date

The results of the HW should be on a spreadsheet and submitted as an attachment to mvergara@pace.edu on Friday November 25th, 2016 no later than midnight.

Submit your HW, even if the program doesn’t run properly.