Question: Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save

Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save your work as a Macro-enabled Workbook, and submit it on Canvas. Reopen your Macro-enabled workbook before you submit to ensure that your VBA programs are correctly saved and workable. Please highlight your final answer in Excel

Please answer the following questions 1-4 by using VBA programing. Screenshot and

Q2. Create a function to calculate the commission that follows the rule below. The commission rate applies to the total sales. Please calculate the commission for $200 sales, $3,500 sales, $8,000 sales, $12,000 sales and 2,000,000 sales. (Use If-Elseif-Else)

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 Finance Questions!

Assignment Peale aniwer the folowing questions by waing VBA programing Screenshot and paste your VBA codes next to your results on Bacol worksheet. Please save your work as a Macro-enabled Workbook...

Please answer the following questions by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save your work as a Macro-enabled Workbook, and...

9:35 Search Back Questions of Assignment 4.docx Please answer the following questions by umy VBA programing, Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save...

could you please complete row 1 all the way across and reference formulas used so i may do the rest Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 v = ab Wrap Te...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Use Broyden's method with x(0) = 0 to compute x(2) for each of the following nonlinear systems. a. b. x21 + x2 37 = 0, x1 x22 5 = 0, x1 + x2 + x3 3 = 0. c. x31 + x21 x2 x1 x3 + 6 = 0, ex1 + ex2 x3 =...

Which features of organizations do managers need to know about to build and use information systems successfully? What is the impact of information systems on organizations? 1. Define an organization...

What are the main determinants of the level of savings in an economy?

JAVA A ball bounces along the - axis between a wall at 0 and another wall at a given distance. The move method advances its position by one unit. When it reaches either wall, it changes direction.