|  You want to calculate a bonus if the sold price was at least equal to the listing price, and if the house sold within 30 days after being listed. In cell L12, insert an IF function with a nested AND function to calculate a bonus. The AND function should ensure both conditions are met: Sold Price divided by the Listing Price is greater than or equal to 100% (cell L7) and the Days on Market are less than or equal to 30 (cell L8). If both conditions are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed cell references to the input values in the range L7:L9. Copy the function to the range L12:L39.
|
G31 for 560000 CO OU AWN- D E F G H 1 J K Total Sold Highest Sold 1 Number Sold Dual Agent Total # Sold Prices Price Agent Codes and Commission Rates 2 Carey BA Buyer's Agent 2.75% 3 Hernandez DA Dual Agency 5.50% 4 Pijuan SA Seller's Agent 3.25% 5 6 Input for Bonus 7 Percent of List 100% 8 Days on Market 30 9 Bonus Amount $ 1,000 10 Agent List Price Days on Selling Agent Agent Type Agent Type Sold Price Listing Date Sale Date Bonus 11 Market Commission 12 Pijuan DA Dual Agency $ 725,000 $ 705,000 4/1/2021 6/16/2021 76 6% $ 13 Pijuan DA Dual Agency $ 350,799 $ 350,000 4/1/2021 5/25/2021 54 6% $ 14 Pijuan DA Dual Agency $ 385,900 $ 385,900 4/1/2021 4/30/2021 29 6% $ 15 Carey SA Seller's agent $ 500,000 $ 495,800 4/3/2021 6/10/2021 68 3% $ 16 Pijuan BA Buyer's Agent $ 345,999 $ 345,000 4/3/2021 6/1/2021 59 3% $ 17 Hernandez DA Dual Agency $ 325,000 $ 320,000 4/12/2021 5/30/2021 48 6% $ 18 Pijuan DA Dual Agency $ 750,250 $ 725,900 4/12/2021 11/1/2021 203 6% $ 19 Carey DA Dual Agency $ 645,000 $ 643,000 4/18/2021 6/23/2021 66 6% $ 20 Pijuan BA Buyer's agent $ 425,000 $ 415,000 4/18/2021 6/30/2021 73 3% $ 21 Pijuan SA Seller's agent $ 325,000 $ 330,000 4/28/2021 6/1/2021 34 3% $ 22 Pijuan SA Seller's Agents 425,815 $ 418,000 4/28/2021 9/15/2021 140 3% $ 23 Pijuan DA Dual Agency $ 700,000 $ 705,000 4/30/2021 6/19/2021 50 6% $ 24 Hernandez SA Seller's Agents 365,000 $ 363,000 5/1/2021 6/18/2021 48 3% $ 25 Carey SA Seller's agents 885,500 $ 800,000 5/1/2021 6/6/2021 36 3% $ 26 Carey SA Seller's Agent $ 610,000 $ 600,000 5/1/2021 6/26/2021 56 3% $ 27 Hernandez DA Dual Agency $ 560,700 $ 565,000 5/1/2021 5/30/2021 29 6% $ 28 Hernandez BA Buyer's agent $ 450,000 $ 450,000 5/2/2021 9/30/2021 151 3% $ 29 Carey BA Buyer's Agents 375,000 $ 372,500 5/6/2021 5/15/2021 9 3% $ 30 Carey SA Seller's Agents 650,000 $ 625,750 5/15/2021 6/9/2021 25 3% $ 31 Hernandez DA Dual Agency $ 545,000 $ 560,000 5/22/2021 6/16/2021 25 6% $ 32 Carey SA Seller's Agent $ 315,750 $ 320,000 5/28/2021 6/18/2021 21 3% $ 33 Carey DA Dual Agency $ 300,000 $ 300,000 6/2/2021 9/2/2021 92 6% $ 34 Hernandez DA Dual Agency $ 589,000 $ 595,000 6/18/2021 7/8/2021 20 6% $ 35 Hernandez DA Dual Agency $ 345,670 $ 345,000 6/20/2021 9/30/2021 102 6% $ 36 Carey BA Buyer's Agent $ 555,000 $ 550,000 6/24/2021 6/30/2021 6 3% $ 37 Carey BA Buyer's agent $ 475,000 $ 485,000 6/24/2021 9/18/2021 86 3% $ 38 Carey DA Dual Agency $ 400,000 $ 400,000 6/30/2021 7/15/2021 15 6% $ 39 Pijuan SA Seller's Agents 380,500 $ 365,750 6/30/2021 9/1/2021 63 3% $ 40
