Question: please help me with what excel formula to put in I9 3.2 Calculate freight cost based on the shipping class and state to which the

please help me with what excel formula to put in I9

3.2 Calculate freight cost based on the shipping class and state to which the shipment is going. a. Place your calculation for the first order in cell 19. b. Use the HLOOKUP function. c. Freight Cost can be referenced on the "Freight Cost" lookup table (range C3:K6 )). d. Hint: You will need to use a nested IF function within the HLOOKUP function to determine the appropriate row. e. Be sure to use appropriate relative and absolute cell references. f. Reuse your formula in cell 19 ) to complete the "Freight Cost" column of the table. 10 (33) Calculate the invoice Shipping Totar: a. Place your calculation for the first order in celi 19 : b. The shipping total is the sum of the insurance and freight costs. c. Reuse your formula in cell 19 to 3.2 Calculate freight cost based on the shipping class and state to which the shipment is going. a. Place your calculation for the first order in cell 19. b. Use the HLOOKUP function. c. Freight Cost can be referenced on the "Freight Cost" lookup table (range C3:K6 )). d. Hint: You will need to use a nested IF function within the HLOOKUP function to determine the appropriate row. e. Be sure to use appropriate relative and absolute cell references. f. Reuse your formula in cell 19 ) to complete the "Freight Cost" column of the table. 10 (33) Calculate the invoice Shipping Totar: a. Place your calculation for the first order in celi 19 : b. The shipping total is the sum of the insurance and freight costs. c. Reuse your formula in cell 19 to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the freight cost in Excel using the HLOOKUP function with a nested IF to determine the ... View full answer

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

Atlas 3 . 0 3 . 2 Calculate freight cost based on the shipping class and state to which the shipment is going. a . Place your calculation for the first order in cell I 9 ) . b . Use the HLOOKUP...

(3.2) Calculate freight cost based on the shipping class and state to which the shipment is going. a. Place your calculation for the first order in cell 19 . b. Use the HLOOKUP function. c. Freight...

3 . 2 Calculate freight cost based on the shipping class and state to which the shipment is going. a . Place your calculation for the first order in cell ( 1 9 ) . b . Use the HLOOKUP function. c ....

Calculate the Invoice "Total" in cell J15? Use the SUM function to calculate the worksheet totals in cells I9, I10 and I11? Use the HLOOKUP function in cell H11 to calculate freight cost based on the...

A C D E F G J K L M N O 2 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment 3 Freight...

A B C D E F G H I J K L M N O 1 2 When shipping products two major costs are incurred: the 3 cost of insuring the item and the actual freight cost. 4 Insurance is dependent on the value of the...

please solve formulas :) 1 1 3 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment....

Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table...

Lookup Functions Use the HLOOKUP function to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range ES:N8). Be sure to use appropriate relative and...

Please help me make this excel spreadsheet. It is for CSIS 100 class and I have no access to excel. Thank you for your time! I can plug my numbers and what not in I just don't have enough time with...

Balamurugan Petroleum expects three years of exceptionally slow growth as a result of the pandemic. Their dividend of $1.0 (D) will increase by 1% for three years before returning the regular growth...

Huron Company produces a commercial cleaning compound known as Zoom. The direct materials and direct labor standards for one unit of Zoom are given below: Standard Quantity or Hours Standard Price or...

A farmer currently produces 4 5 , 0 0 0 bushels of corn a year. He can increase his harvest by an average rate of 3 percent annually. How long will it be until the farmer can produce 5 0 , 0 0 0...

How many campervans and tents should be kept in camping site to keep costs as minimum? Q 1) A camping site owner keeps at least 30 campervans and 20 tents in his camping site to rent the campers one...

2. What technologies are used by UPS? How are these technologies related to UPSs business strategy? United Parcel Service (UPS) started out in 1907 in a closet-sized basement office. Jim Casey and...

2. Identify the problems that businesses in this case study solved by using mobile digital devices. How much of your job can you do from the palm of your hand? Probably more than you think. Today...

1. What kinds of applications are described here? What business functions do they support? How do they improve operational efficiency and decision making? How much of your job can you do from the...