On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference. D E F G H J K M N A B 1 Orlando Area Job Fair 2 Annual Attendance by Location 3 Compiled On: 11/4/2015 Projections: 2018 Analysis 2020 2015 2109 8145 4879 2641 2325 3879 4873 2151 2016 1988 9683 5105 2598 2018 2018 Increase 2307 60 10657 453 4000 2000 150 4501 1,601 3548 228 5687 376 32,700 2017 2247 10204 4952 1850 2900 3320 5311 20,784 2018 Percent of 2018 Total 2018 Total Total Admission Fees Profit 7% $ 36,796.65 $ 47,301.28 33% $ 169,979.15 $203,715.36 12% $ 63,800.00 $ 76,925.4 6% S 31,900.00 $ 41,583.12 14% S 71,790,95 $ 88,174.02 113 S 56,590.60 $ 69,893.57 17 S 90,707.65 $ 106,215.52 $ 521,565.00 $631, S. 35 2018 X of Profit from Admission 78% 83% 83% 77% 81% SI 85% 256 1186 445: 2019 2422 11190 4200 2100 2542 3764 4998 30,678 3725 5971 34,335 5011 394 6331 36,195 4 Location 2014 5 Altamonte Springs 1580 6 Central Orlando 7873 7 Caselberry 4580 8 Kissimmee 2520 9 Lake Mary 1938 10 Mount Dora 3647 11 St. Cloud 4687 12 Total Attendance: 13 14 2018 Admission Fees S 15 95 15 16 Total Attendees (2014-2018): 149,838 17 Total Locations: 7 18 19 2018 Statistics 20 Average Attendance 4,671 21 Median Attendances 4.000 22 Minimum Attendance 2.000 23 Maximum Attendances 10,65 City Name: Kissimmee 2018 Percentage OX Profit from Admission Goal 30% IF I = logical Logical_test Valuc_if_true Value_if_false any ES = any Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Logical test is any value or expression that can be evaluated to TRUE FALSE. Formula result OK Cancel Help on this function