Hello, i am suppose to use the IF and VLOOKUP function to calculate the shipping costs in excel but am not sure how to go about this.

W N 1. "Express." Structure Requirements each shipment: Name J. Baker J. Janes G. White M. Suciu P. Bryan L. Goffman Customer G. Henderson samples with the following data shown below: Shipping Weight Pounds calculates the total shipping cost for packages weighing 30 pounds or Total Shipping Cost: This equals the fuel tax plus the shipping cost. Shipping Cost: Determined from shipping cost tables on the next page. Shipping Regula Method Regular Express Regular Express Express Express In addition to the columns above, your spreadsheet should calculate three additional columns for Fuel Tax: $1 if the shipping method is "Regular" but $2 if the shipping method isversa. 26 to 30 pounds 21 to 25 pounds 16 to 20 pounds 11 to 15 pounds Shipping Cost Tables 6 to 10 pounds 1 to 5 pounds Range Weight Regular Delivery Shipping Cost Hints: You will need to use the Excel functions IF and VLOOKUP in order to complete this That is, two VLOOKUP functions will need to be contained within the IF function, OR vice from shipping cost tables. Moreover, you will need to "nest" the IF and VLOOKUP functions. spreadsheet correctly. The VLOOKUP function should be used to "lookup" and display figures 11 to 15 pounds 16 to 20 pounds 21 to 25 pounds 26 to 30 pounds 6 to 10 pounds 1 to 5 pounds Weight Range Express Delivery O Shipping $14 $20 $16 Cost $2 $32 $28