11:34 PM Thu Jan? Take Quiz Search Engine 2 List of Rental Property U 7. 101 YA ago Meadow Ron Med 103 10 10 1 1 2 19 0 5 $ $ $ $ 300 11 12 2004 2004 2009 14 1 2 2 1 1 10 30 180 203 200 2009 JE 23 18 29 20 21 Holi Me Rolling Meadows Meadows Rolling Meadows Rolling Meadow Rolling Meadows Rolling Meadows Rolling Meadows Rolly Meadows Rolling Meadows Rolling Meadow Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Lakeview Apartments takeview Apartments Lakeview Apartments 5 . 5 150.00 5 5 56.00 5 000.00 500.00 3 350.00 5 350.00 $ 1.000.00 $ 1.000.00 $ 775.00 5 3.00 5 5 87.00 $ 1.050.00 $ 1.050.00 $ 75.00 $ 875.00 $ 1.050.00 $ 1.000.00 5 $ 75.00 5 hin Yes ho Yes No ves Yes Yes Yes NO Yes 1 2 2 3 1 2 2005 2010 2010 2010 2010 2004 2004 2004 J008 2004 2006 2005 2001 2001 204 205 200 202 200 200 210 101 102 303 75.00 Noche 75.00 NO 75.00 ed to remodel 78.00 No change 3.0 No change 15.00 Na chance 11. Need nedel 125.00 Mochane 128.00 No change 128 09 10 thang 75.00 Nodange 75.00 No change 125.00 No change 139.00 No change 73.00 hange 300 Need to remodel 75.00 Nodange 75.00 No change 75.00 Need to remodel 25.00 No change 75.00 No change 75.00 Need to remodel 75.00 Need to remodel $ $ $ $ 5 $ 5 $ $ 5 5 $ $ 5 $ $ $ 20 25 2 31 20 1 3 1 1 1 Yes Yes NO Yes NO No No In the spreadsheet above, if the apartment is unoccupied and was last remodeled before 2005, display recommendation Need to remodel, if not display No change. What is the formula for recommendation in H7? =IF(AND(E7="no".F7-2005)"Need to remodel"No change") =IFOR(E7="no"F72005), "Need to remodel", "No change")