Can someone please help me with this Excel assignment? I figured out the IF function for total (I don't know if its right).

Maxwell Directions 1. Maxwell Scientific offers a 5% discount if customers order more than 50 units of a particular product. Use an IF function to calculate the discount for each product. The format of the IF function is =IF(logical test, true, false) The logical test is how you'd determine if a discount should be given. The true argument is how the discount is calculated if the discount is given. The false argument is the amount of the discount if no discount is given. 2. Also, customers can choose between two shipping options: standard shipping for a cost of $4.95, and express shipping for a cost of $9.95. Use an IF function to calculate the shipping charge. The format of the IF function is =IF(logical test, true, false) The logical test is how you'd determine if standard shipping has been chosen. true argument is the amount for standard shipping. The false argument is the amount for express shipping. 3. Enter formulas to calculate the total amount of each order and the total amount of all the customer orders. You'll need to use the shipping and discount information to calculate each row total. 4. Preview the completed Orders worksheet, and save the file. 5. Maxwell Scientific is considering changing its bulk discount rate from 5% to 8%. It is also looking at changing standard shipping charges to $5.50 and express shipping to $10.95. 6. Copy the Orders worksheet to the end of the workbook. Rename this worksheet New Orders. 7. Change the discount rate to 8% and the shipping charges to $5.50 and express shipping to $10.95. 8. Save the workbook as Maxwell3 and then close the workbook. The file must be in Excel format. PDFs are not accepted and will earn no points. Submit the file using the link provided in Blackboard. Formatting as E9 x fx A B D E F G H I J K L M Discount A Discount p: 50 5% 1 Maxwell Scientific 2 Special Pricing 3 Discount rate for order quantities > 50 4 Shipping Standard 5 Express 6 7 Order Table 5% $4.95 $9.95 Shipping Shipping Cost 8 Customer Product Price Qty Price Qty Discount Total 9 Toki Middle School Night Disks Standard $9.50 60 $570.00 $541.50 10 Wright Elementary Solar Mobile Express $9.50 25 $237.50 $237.50 Address 45 Crawford Lane Middleton, IA 1231 Oak Avenue Treelane, KY 32108 Raulings, MN 89183 100 Main Street Edgerton, CA 75531 11 Hawthorne Academy Night Disks Standard $9.50 10 $95.00 $95.00 12 Lewis Museum Planet Cards Standard $4.95 250 $1,237.50 $1,175.63 9 South Street Chilton, LA 55831 Solar Mobile Express $9.50 150 $1,425.00 $1,353.75 Total 13 Adler Planetarium 14 15 16 17 18 19 20 21 22 23 24