The delivery charges used in the Delivery worksheet are as follows: ¢ For orders under $10, there
Question:
¢ For orders under $10, there is a $6 delivery fee.
¢ Orders of at least $10 but less than $40 have a $7.50 delivery fee.
¢ Orders over $40 are delivered free of charge.
Create a lookup table for the Delivery worksheet so that you can use a lookup function to calculate the delivery cost for each order. Organize the table in a horizontal format.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach
ISBN: 978-1285715346
1st edition
Authors: Debra Gross, Frank Akaiwa, Karleen Nordquist
Question Posted: