On the Inventory worksheet, insert a function in E$8$:E$157$ to calculate the number of

days each ring has been in inventory using $10/1/2018$ as today$$s date.

$3.$ Insert a function in F$8$:F$157$ that will display $10\%$ Discount$$ for rings that have been

in inventory more than $365$ days, $5\%$ Discount$$ for rings that have been in inventory

between $150$ and $365$ days, and nothing for the remaining rings.

$4.$ Insert a function in cell H$3$ that will calculate the average price of all rings in

inventory.

$5.$ Insert functions in cells I$3$:L$3$ that will calculate average cost of all rings in inventory

greater than or equal to $1$ carat, less than $1$ carat, in inventory $1$ year or more, and in

inventory less than $1$ year, respectively.