INSTRUCTIONS:

$1)$ You need to find the average cost of each product. To find the average cost, you will need to divide the cost basis by the quantity on hand. However, some calculations may cause an error.

Use the "IFERROR" function in column D to calculate the average cost. The value for any errors should be $0.$

$2)$ Calculate the number of days it took from the date the product was shipped to the date the product was received.

Use an $"$IF$"$ and "ISBLANK" function in column G to find the number of days it took to ship. If there is not a Shipping date, the number of days can be blank.

Note: this can be reflected in your formula by placing two empty quotes $($Ex: $"").$

Otherwise, subtract the "Shipped Date" column by the "Date Received".