pls help me with this and follow the instructions
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 The 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. 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. quantities > 50 Standard Express 5% $4.95 $9.95 Qty Price"Qty Discount Total 60 $570.00 25 $237.50 Shipping Address Product Shipping Cost Price 45 Crawford Lane Middleton, IA Night Disks Standard $4.95 $9.50 1231 Oak Avenue Treelane, KY 32108 Solar Mobile Express $9.95 $9.50 Raulings, MN 89183 Night Disks Standard $4.95 $9.50 100 Main Street Edgerton, CA 2 75531 Planet Cards Standard $4.95 $4.95 9 South Street 13 Chilton, LA 55831 Solar Mobile Express $9.95 $9.50 10 $95.00 250 $1,237.50 150 $1,425.00 Total
