Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(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
(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 (3: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. aujnaid(F) (3.3) Calculate the Invoice "Shipping Total". a. Place your calculation for the first order in cell j9. b. The shipping total is the sum of the insurance and freight costs. c. Reuse your formula in cell d ) to complete the "Shipping Total" column of the table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started