Use an IF function in Cell J9 to calculate the Tax There is a tax of 5 percent applied on shipments to Utah A 6 percent tax is applied on shipments to Oregon There is no tax on shipments to other states Refer to the appropriate discounts in cells C4, C5 and C6 for your IF function arguments Use absolute and relative references when appropriate

Question

Use an IF function in Cell J9 to calculate the Tax  There is a tax of 5 percent applied on shipments to Utah  A 6 percent tax is applied on shipments to Oregon  There is no tax on shipments to other states  Refer to the appropriate discounts in cells C4, C5 and C6 for your IF function arguments  Use absolute and relative references when appropriate

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: Use an IF function in Cell J9 to calculate the Tax. There is a tax of 5 percent applied on shipments to Utah. A 6

Step by Step Solution