Help QuickBooks Review View Page Layout Formulas Data Draw Insert Fle Home Autoum Cat Copy Jfomat Painter A A 11 Whap Text General Calibri Sort & Find & FiterSelect de Conditbnal Fomat as Cel Fomattinglable Styles Inset Delete format Clear % A EE Merge& Center BI idear Edting Cel Styles Nunben Alignment Cipboard Fonts fr 1 Product Lookup Springleaf Designs- Merchandise Datar Current Current Sales Sale Needed Time on Overall Sales Product Accessory Sale Needed Total Sales Launch Date Product Name Sales Rank Market (Yrs) Rank Type S Metallic Earrings $ 4495,870 S 235905 118,87 105,044 3/17/2013 4 Beaded Earrings Metallic Earrings Head Cuff Bracelets 4 Head 9/1/2014 11/15/2014 4/15/2014 2/11/2015 2/17/2015 1/19/2014 s0/22/2015 Scarves 686,809 S IS 2574871 S 1784517 S S3373430 s S 1012.569 5 29,929 Head 11 6 Combination Earrings 96,490 21 7 Beaded Bracelets Arm 6 301,116 Bangle Bracelets Arm 101,712 5 Culf Bracelets Arm 78,771 10 Necklaces Body Body Body 4 741.057 105,231 11 Leather Belts 974569 s Fabric Betu 93.962 6/23/2015 12 10 s08.022 56544 13 Body 8/13/2015 4/8/2016 11 Scarves 647.318 106,302 Body 10 2 14 Purses Totol 15 16 Average High Low 17 18 00 19 Dato Updated 10/14/2016 20 27 Current Date 22 23 24 25 26 Documentation Merchandise Projections Sales Summary 10. Geneva's manager would like to see some additional information to help make sales decisions. Enter a formula in cell 14 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) If this condition is true the item will go on sale. (Hint: The if true value should be "YES) a. If this condition is false, the item doesn't need to go on sale. (Hint: The if_false value should be "-".) b. Copy the formula created in cell J4 to the range J5:J14