1U. Gene 'ua's manager would lilce to see some additional infonnation to help malce sales decisions. Enter a lhrmula in cell Jil- using the IF function to it whether or not the item Eleaded Earrings should go on sale. It will go on sale ifil: current sales ranlc [in cell Grill is Ether lower: [Hints ifthe cell value is greater than or equal to 3, it will go on sale-] a- Itthis condition is true. the item will go on sale. [Hint The if_true value shoulcl he ""I"ES".:| h- Itthis condition is 1l'alse. the item doesn't need to go on sale. II'Hr'nL' The il:_l'alse value should he "-"J c- Copy the armula created in cell Hto the range]5:jl4. 11. Enter a JFormula in cell E4 to calculate how long each item has been on sale. This is calculated by subtracting the launch date in cell D4 From the Data Updated date in cell C1.To showthe time in vears. divide that result hvBI- Use an absolute reference to the date in cell {321}. Copy the Jinr'r'nula 'om cell E4 to cells E5:E14