Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions