Maxwell Directions with Formulas

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 formula for the first discount is given in I$9.$ Click of this cell to see the formula. Use this formula to copy down into the rest of the bordered cells in column I.

Also, customers may choose between two shipping options: standard shipping for a cost of $$495,$ and express shipping for a cost of $$9\mathrm{.}95.$ Use an IF function to calculate the shipping charge. The formulas for the first shipping charge is given in E$9.$ Use this formula to copy down into the rest of the bordered cells in that column.

Enter formulas in Column $H$ to multiply the values in Column $F$ times Column $G$ in each of the rows of bordered cells. Your formula must begin with an equals sign and use the cell addresses for each of the cells in columns F and G$.$ Use the $*$ symbol for multiplication.

Enter formulas to calculate the total amount of each order for each row and the grand total amount of all the customer orders in cell J$14.$ Use the shipping and discount information to calculate each row total. Your formula must begin with an equals sign. Decide what should be added to the value in column $H$ and what needs to be subtracted in each row to calculate each row total. Lastly, calculate the grand total in J$14$ using cell addresses.

Save the workbook as Maxwell$3$ and then close the workbook. Submit the file using the link provided in Blackboard.

$f_x$ Enter text or formula here