Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
To calculate the freight cost in Excel using the HLOOKUP function with a nested IF to determine the ...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