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 (range E5:N8). Be sure to use appropriate relative and
absolute cell references.
Hint: You will need to use a function within the HLOOKUP function
to determine the appropriate row. Please provide formula .
The formuale here we need to use is HLOOKUP and within HLOOKUp
we need to use match function.
Please have the below formuale in H11 and drag it down
=HLOOKUP(B11,$E$5:$N$8,MATCH(F11,$E$5:$E$8,0),FALSE)
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class...
Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the ÒValueÓ in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately. please provide formula 2When shipping products two major costs are incurred: the cost of insuring 3 the item and theactual freight cost. Insuranceis dependent on thevalue of 4 the shipment 5 Quickstove has an agreement with shippers for a fixed...
Home InsertPage Layout Formulas Dat Lookup Functions 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 (range E5:N8). Be sure to use appropriate relative and absolute cell 3 Hint: You will need to use a function within the HLOOKUP function to determine the fz -VLOOKUP(F11,E$6:NS8,H LOOKUP·ー [6 points] When shipping products two major costs...
I need help with these functions please Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility Sales tax is not charged on shipments to other states. Task # Points...