Question: Open the VBA Editor and create a new module. Create a new function named freight. Craft this function to calculate cost * rate. Can you

Open the VBA Editor and create a new module. Create a new function named freight. Craft this function to calculate cost * rate.

Can you please just show me the steps to create this function in excel?

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!

Q:

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up...

Q:

1. Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange theme colors. 2. Unlock the ranges B15:K17 and D4:D12. 3. Record a macro named Sort . Ensure the macro...

Q:

This requires solution in MS Excel. 2 Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange theme colors. 3 Unlock the ranges B15:K17 and D4:D12. 4 Record a...

Q:

1. Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange theme colors. 2. Unlock the ranges B15:K17 and D4:D12. 3. Record a macro named Sort . Ensure the macro...

Q:

1. Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange theme colors. 2. Unlock the ranges B15:K17 and D4:D12. 3. Record a macro named Sort . Ensure the macro...

Q:

5 Record a macro named Sort, be sure to use relative references. Ensure the macro sorts the data in the table in ascending order based on SKU (column A). Stop the Macro Recorder and Save the workbook...

Q:

problems 7 and 8 I keep getting wrong. I need help with cell D13. I know the formula should be depreciation(D12,D14) and the content should be DEPRECIATION but I keep getting the #REF! error in the...

Q:

Exp19_Excel_Ch12_ML2_Travel_Expense Project Description: You are a financial analyst for VJD Financial, a wealth management company with 10 offices located across the United States Currently your...

Q:

n viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Bradet Instructors Excel 2019 Pd Exp19_Excel_Ch12_ML_Travel_Expense Project Description: You are a financial...

Q:

Exp19_Excel_Ch12_ML2_Travel_Expense Project Description: You are a financial analyst for VJD Financial, a wealth management company with 10 offices located across the United States. Currently your...

Q:

During October, Wichita Light Company experiences the following transactions in establishing a petty cash fund. Oct. 1 A petty cash fund is established with a check for $150 issued to the petty cash...

Q:

Write a paper on Meditative Buddha Statue

Q:

maturty is 3 . 7 5 pencent, what is the ourtut plice per bond? Mathe Clew 6 1 4 4 5 2 4 0 9 % 6 4 8 4 2 4 5 1 9 0 4 4 aitis maturly is 3 3 5 grreent, whet is the corvent ploes per boed? Uhipe Orolice...

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

Read the article summarised in focus on research 11.7 and suggest other HRM actions that the organisation could have taken after the strike to meet the employees aims.

Q:

Role- play the situation of an interview with an employee coming back to work in an engineering environment after an extended period of absence through having a bad back.

Q:

What types of specific skills (such as knowledge of financial accounting methods) do you think HR professionals will need to have the business, professional-technical, change management, and...