1 2 3 4 5 6 7 A Number 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 221 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 C Where The city The Suburb The Suburb The Suburb The city The city The city The Suburb The city The city The Suburb The city The Suburb The city The Suburb The city The city The city The city 4081 Lybyer Avenue The city The Suburb 1900 Glenview Road 9000 South Suncot Avenue. The city B Address 8687 Kenwood Road 11 West Oak Circle 314 Timp View Drive 614 West Cedar Drive 750 South Apple Way 7 Kingston Court 618 West Cedar Drive 321 North Choctaw 1370 Pinellas Road 1971 Glenview Road 15 West Oak Circle 575 South Choctaw 10995 SW 88 Court 143 North Mountain View 29 East Oak Circle 8030 Steeplechase Drive 2006 Cutwater Court 9876 South Sunset Avenue 321 West Walnut Grove D Selling Agent Hernandez Carey Goodrich Lugo Goodrich Carey Lugo Minkus Lugo Minkus Hernandez Goodnch Goodrich Carey Merkin Merkin Minkus Hernandez Goodrich Minkus Hernandez Lugo E Selling P Commission $ 725,000 $ 350,000 418,000 $ $ 215,800 $ 385,900 $ 500,000 $ 300,000 $ 565,000 S 219,000 S 165,000 $ 325,000 S 720,250 $ 110,000 $ 314,250 $ 565,000 $ 450,000 $ $ S $ $ S 345,000 300,000 425,000 325,000 325,000 325.000 This is a vlookup table question with an if statement. The table green is to calculate appliable percentage based on the Commission. The if statement is ibased on column what is in column"C" call "Where" "The city" or the "The Suburb will determine the percentage Commission. Calculate the commission based on the selling price SellingP The city 100000 200000 300000 500000 600000 750000 3.00% 3.50% 4.00% 4.50% 5.00% 6.00% The Suburb 4.00% 5.00% 5.50% 6.00% 6.50% 7.50%

This is a vlooinup table question with if if statement. The table green ia to calcilate appliable percentage based on the commisuis The if stakement is baved on column what is in column"Cr.cal where" "The ofy" or the "The suburb will determine the percentage Camminstoen Cilculate the commisuinn based on the seling price