Modify the formula in G$16$ by adding an IFERROR function to the existing function to

display either the price of the item or a blank cell if an error value occurs. Copy this formula

to the bottom of the invoice.

In the Total column, enter a formula to calculate the total charge for that row. Use the

IFERROR function to display either the total charge or a blank cell if an error value occurs.

Copy this formula to the bottom of the invoice.

In the Subtotal cell, insert a formula to calculate the total charge for items ordered. Use the

IFERROR function to display either the total charge or a blank cell if an error value occurs.

In the sales tax cell, enter a formula that will display the sales tax so if the customer's

province is ON$,$ then calculate $13\%$ of the subtotal. If the province is something other than

ON$,$ the sales tax will be $5\%$ of the subtotal. In the Shipping cell. use the IF and ylookup functions to determine the shipping cost. If the

subtotal is $0,$ the shipping cost should be $0.$

In the Total Due cell, enter the correct formula.

Enter the following data into the worksheet and check that it works:

Item $1.$

Flavour:

Quantity:

Item $2$:

Flavour:

Quantity:

Standard $(2)2$ g

Sour Mash

$4$

Fancy Tin $3$g

Buttered

$3$

Save your workbook.apply the instructions in excel sheetCase $3-$ Jay's Popcorn $(17$ marks$)$

Marnie Turcotte established Jay's Popcorn in Sauble Beach, ON in $2016$e

Flavours table. The input message title should be "Flavour" and the input message should

rea