The shipping cost for most transactions is 10% of the sales value, however, sales to the southeast region are at 20%.

- In column F, use an IF() for each row of data to compute the shipping costs.

So basically, I'm trying to figure out how to use the IF function to enter into column F. This is an example that my teacher gave, I'm just not sure how he got these values using the IF function.

F A B 1 Year Region 2017 West 2017 Northeast 2017 Midwest 2017 Northwest 2017 West 2017 Northeast 2017 West 2017 Northwest 2017 Southeast C D E Sales Expense Code 94.7 61.555 236.5 160.82 73.8 47.97 337.9 219.635 284.3 196.167 101.2 67.804 169.5 115.26 112.5 70.875 261.2 169.78 Shipping o $ 9.47 1 $ 23.65 0 $ 7.38 1 $ 33.79 1 $ 28.43 0 $ 10.12 O $ 16.95 0 $ 11.25 1 $ 52.24