The data provided for this exercise contains sales transactions from a retail store that sells furniture and $\backslash$table$[[$tomer ID$,$Customer Name,Product ID$,$Category,Sub$-$Category,Product Name,Sales,Quantity,Discount,Profit,Shipping Cost,Final Shipping Cost,Product Category$],[11280,$Toby Braunhardt,OFF$-$TEN$-10000025,$Office Supplies,Storage,Tenex Lockers, BI$,408\mathrm{.}3,2,0,106\mathrm{.}14,35\mathrm{.}46,0,],[15985,$Joseph Holt,OFF$-$SU$-10000618,$Office Supplies,Supplies,Acme Trimmer, H$,120\mathrm{.}366,3,0\mathrm{.}1,36\mathrm{.}036,9\mathrm{.}72,9\mathrm{.}72,],[735,$Annie Thurman,OFF$-$TEN$-10001585,$Office Supplies,Storage,Tenex Box, Single,$66\mathrm{.}12,4,0,29\mathrm{.}64,8\mathrm{.}17,8\mathrm{.}17,],[14140,$Eugene Moren,OFF$-$PA$-10001492,$Office Supplies,Paper,Enermax Note Ca$,44\mathrm{.}865,3,0\mathrm{.}5,-26\mathrm{.}055,4\mathrm{.}82,4\mathrm{.}82,],[15985,$Joseph Holt,FUR$-$FU$-10003447,$Furniture,Furnishings,Eldon Light Bulb, I,$113\mathrm{.}67,5,0\mathrm{.}1,37\mathrm{.}77,4\mathrm{.}7,4\mathrm{.}7,],[15985,$Joseph Holt,OFF$-$PA$-10001968,$Office Supplies,Paper,Eaton Computer I,$55\mathrm{.}242,2,0\mathrm{.}1,15\mathrm{.}342,1\mathrm{.}8,1\mathrm{.}8,]]$

office supplies. With the provided exercise data, use skills from the video to perform the following:

To encourage higher sales volumes on each order, this business would like to offer free shipping on

orders that total over $$200$ in total sales. Create a new column called "Final Shipping Cost" that calculates

the shipping cost for each row as either $$0$ if the Sales column is over $$200$ or the already calculated

Shipping Cost otherwise.

The company needs to calculate sales tax on all orders and the sales tax depends on the category of

products sold according to the table below. Use an IFS function to determine the sales tax rate for each

order in a new column. The sales tax rates for each product category are in the table below. Then, also

calculate the sales tax amount by multiplying the percentage by the total sales in another column.

I need help with question $2$ im so confused