What equation would I use for cell I6 if I were using the filters in cells G1:U2 to find my output in cell I6. Also, the purpose of this spreadsheet is to find which house, I would live in based off of the filters (the data in cells G2:U2 is sample data)

AutoSave OFF Higher Education Tool Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View Developer Share 0 Comments X Calibri (Body) v 12 v P ah Wrap Text General + 2 Insert v Delete Format v 4 V v Paste 4 Av = = = Merge & Center v Il 3:11 Y Conditional Format Cell Formatting as Table Styles Ideas Sort & Filter Sensitivity V Find & Select J7 F N Y G H What college are you going to? University of Michigan-Dearborn L How many bedrooms? . fox A B C Student Housing Hero College University of Michigan-Dearbom University of Michigan-Ann Arbor Michigan State University Central Michigan University How much saft? 2011 How many bathrooms? P a R How far away from campus? 4 Miles ST U How much for rent a month? $1,700 1 2 3 4 5 Location Dearborn Ann Arbor East Lansing Mount Pleasant House# # House# Hause Hause Results if your living in Dearborn ZIDI Results if your living in Ann Arbor Results if your living in East Larsire Results if your living in Mourt Pleasant House Price Per Month House# Houses around Dearborn 50 Ft Bedrooms Bathrooms Disctance from Campus 1917 3 2 5 Miles Houses around East Lansing Sq. Ft Bedrooms Bathrooms Disctance from Campus 1545 3 9 Miles Price 1101 $1,400 1E $ 2DI 2011 2 4 Miles $1,700 ZE] 2121 4 3 4 Miles $ Address 7535 Appoline St Dearborn, Michigan MI), 48126 5430 Wessex a Dearborn, Michigan MI), 48126 , 3407 Houston St Dearborn, Michigan MI), 48124 321 Brentwood Dr Dearborn Michigan MI), 48124 Address 909 Sunset L East Lansing, Michigan MI), 48828 920 Longfellow Dr East Lansing, Michigan MI), 48823 5650 White dover Dr East Lansing, Michigan MI), 48823 747 Beech St East Lansire Michigan MI), 48823 310) 1153 7 1.5 7 Miles $1,100 3F1 1190 1 9 Miles 9 $ 410 1464 1.5 9 Miles $1,200 4E 1977 4 2 6 Miles $ 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Houkes around Ann Arbor 5. FL. Bedrooms Bathrooms Disctance from Campus Houses around Mount Pleasant Sq. Ft Bedrooms Bathrooms Disctance from Carnpus House 1 House Price Price Per Month $1,900 11A 1615 3 1.S 5 Miles 1M) 1489 2 12 Miles $ 21A1 2446 4 2.5 10 Miles $2,100 21M) ) 1067 2 2 8 Miles $ Address 439 S Ashley St Ann Arbor, Michigan Mil, 48103 1693 Cypress Pointe Ct Ann Arbor, Michigan MII, 48108 1417 W Uberty St Ann Arbor, Michigan Mil, 48102 1097 Ravenwond Ave Ann Arbor, Michigan MII, 48103 Address 12 Kensington Cir Mount Pleasant, Michigan(MI), 48858 411 N Harris St Mount Pleasant, Michigan(MI), 48958 1516 E Gaylord 5t Mount Pleasant, Michigan(MI). 49958 2190 Otto Dr Mount Pleasant, Michigan(MI), 48858 BIAI 1587 3 3 2 8 Miles $1,700 BIM) 1881 4 2 10 Miles $ 4A) 1379 7 1 5 Miles $1,600 AM) 1619 3 1.5 4 Miles 4 $ 35 37 38 39 40 41 Sheet1 + Ready 1 - + 100%