Set the STATUS column to "Sell" if the "# OF RENTALS" column has a value greater than 100, but if the value is not greater than 100 then set the "STATUS" column to "Replace" only if the "# OF DEFECTS" divided by "# OF RENTALS" is greater than 35%, otherwise, set it to blank.

SPOTLIGHT VIDEO DEFECT REPORT Solve using IF function [2 points] QI: Set the STATUS column to "Sell" if the "# OF RENTALS" column has a value greater than 100, but if the value is not greater than 100 then set the "STATUS" column to "Replace" only if the "# OF DEFECTS" divided by "# OF RENTALS" is greater than 35%, otherwise, set it to blank. #OF RENTALS #OF DEFECTS STATUS ID MOVIE TITLE Walk the Line (2005 2 Yours, Mine and Ours (2005 3 The Weather Man (2005 4 North Country (2005 5 Domino (2005 100 101 100 Saw II (2005 7 Rent (2005 255 10 8 Just Like Heaven (2005 9Eizabethtown (2005 26 12 10 Zathura: A S 13 11 Flightplan (2005 14 12 Waitin 15 13 In Her Shoes (2005 16 14 Corpse Bride (2005 17 15 The Legend of Zomo 18 16 Proof (2005 19 17 Lord of War (2005 20 18 The Ice Harvest (2005 21 19 Pride & Prejudice (2005 22 20 Transporter 2 (2005 23 21 Red Eye (2005/ 24 22 /Wallace & Gromit in The Curse of the Were-Rabbit (2005 25 23 Doom (2005 26 24 Wedding Crashers (2005 27 25 The Man (2005 28 26 The Constant Gardener (2005 29 27 The Fog (2005 30 28 Hustle & Flow (2005) 31 29 The Prince and Me 2 (2006 32 30 The Aristocrats (2005 33 31 Supercross (2005 34 32 MirrorMask 35 33 Where the Truth Lies (2005 36 34 Into the Blue (2005 37 35 Two for the Money (2005 38 36 Broken Flowers (2005 39 36 Four Brothers (2005) Adventure 20 W g(2005/l 26 320 24 74 54 26 26 78 100 54 98 46 40 78 69 40 38 Must Love 41 39 The River K 42 39 |Stuart Littie 3: Call of the Wild (2005 43 41 The Cave (2005 44 42 The Thing About My Fo 45 43 Separate Lies (2005 46 44 |Cinderella Man (2005 47 44 Mr. & Mrs. Smith (2005 48 44 Underclassman (2005 49 47 The 40 Year Old Virgin (2005 50 47 The Brothers Grimm (2005 2005 2005 83 40 Folks (2005 89 102 100 100 82 51 49 Nine Lives 52 50 Thumbsucker (2005) 53 40 56