1. Business
  2. Operations Management
  3. what are the excel formulas here...

Question: what are the excel formulas here...

Question details

use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a | | 6 | discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate. 21Reuse your formula in cell G15 and paste it down to complete the Net Price column of the table. 3 2Multiply the OQuantityO by the ONet PriceO to get the OSale AmtO in Cell H15 4 1Reuse your formula in cell H15 and paste it down to complete the ÖSale Amtó column Use an IF function in Cell 115 to calculate the Tax. There is a tax of 5% applied on shipments to Utah, 696 applied on shipments to Oregon, but no tax on 5 2shipments to other states. Refer to the appropriate tax rates in cells B10, B11 and B12 for your IF function arguments. Use absolute and relative references when appropriate. 6 3Reuse your formula in cell 115 and paste it down to complete the ÓTaxó column 7 2 9 1 Calculate the Invoice OTotalO in cell J15 | Reuse your formula in cell J15 and paste it down to complete the OTotalO column 6 Use the SUM function to calculate the worksheet totals in cells I9, I10 and 111 8 | 9What are the excel formulas here?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution