I need help on step 5. Clear explanation please on entering. I am entering =IF(AND(G12/F12>=$L$7,J12

Still nothing for me. Could you tell me what to enter for each field to ensure I am doing that right.

12 C D F M H Highest sold Price Number Sold Total Sold Prices Total Sold Dual Agent Carey Hamander Puan Agent Codes and Commission Rates RA Buyer's Agent 2.75% DA Dual Agency 5505 SA Sales Agent 3.25 input for Bonus Percent of L Days on Mart Bonus Amount 100 30 1000 S Bonus A B Average Sold 1 Location Price 2 Alpine 3 American Fork Cedar Hills 5 Leht Total Commission by Agent 7 Carey B Hemander 9. Puan 10 Number City 11 12 1 Cedar His 13 4 Lai 14 5 American Fork 15 6 Alpine 10 7 17 10 American Foa 18 12 Alpine 19 17 Albino 20 19 American Foo 21 23 Lehl 22 24 American For 25 27 Alpine 26 30 LAN 25 32 Cadar 20 34 Cadar Hills 27 35 Cedar 24 30 Aman Fork 29 43 American Fox 30 46 Cedar Hili 31 48 Alpine LEN Selling Agent Agent Type Agent Type Puan DA Dual Agency Plan DA Dual Agency Plan DA Dual Agency Carey SA Sears Agent Puan BA Buyer's Agent DA Hamander Dual Agency PN DA Dual Agency Carey DA Dual Agency Pun BA Buyer's Agent SA Puan Selor's Agent SA Puan Sel's Agent Puan DA Dual Agency Hemander SA Seter Agent Carey SA Ser Agent Cany SA Sales Agent Homander DA Dual Agency Homander BA Buyer's Agent BA Buyer's Agent SA Sellers Agent Hemandez DA Dual Agency CA List Price Sold Price 5 725000 705,000 S 350 799 350.000 5 3B5900 385 000 5 500,000 $ 495.800 $ 345,999 345,000 $ 325,000 $ 320,000 $ 750 250 725,000 $ 145,000 $ 643,000 $ 425.000 415.000 5 325,000 330.000 S 425,81515 418.000 $ 700.000 705.000 $ 365 000 $ 383 000 $ 885 500S 100 000 610.000 5 600.000 $ 580.700 S 565 000 $ 450 000 $ 450.000 $ 375 000 $ 372,500 $ 650 0005 625,750 $ 545.000 560,000 ST Listing Date Sale Date 4/1/20 0/1621 4/1/21 5/25/21 4/12 4/30/21 4/321 6/10/21 4321 6/121 12/21 50021 4/12/21 111121 4/1821 6/2321 6/18/21 6/30/21 4/2020 12 412121 9/15/21 473021 /1921 5/1/21 8/18/21 5120 81621 1/21 82021 S21 50021 5/2/21 20021 5/6/20 511521 5/15/21 9/21 5/2221 6/1621 Days on Agent Market Commission 70 5 38.775.00 54 $ 19.250 00 295 21 224 50 6S 16.113.50 50 5 9.487 50 40s 1760000 2035 39 924 50 66 $ 35.365 00 73 $ 11 412.50 34 5 10.725.00 1405 13.585.00 50$ 38.775.00 485 11.797.50 365 20 000 00 505 19,500.00 20 S 31.075.00 1513 12375.00 5 10.243.75 251 20.336 0 255 30.10000 Carey CARY Details Map Loan + Ready A W 0 MacBook Pro #1 I 1 R 01 - C 36 Fion SOURCES Assignment Instructions 5 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 SO. Use mixed cell references to the input values in the range L7:L9. Copy the function to the range L 12:L39