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.
e02h3JobFairAttendance Microsoft Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW SIMS ? Define Name fUse in Formula ?Create from Selection Defined Names Trace Precedents mE Trace Dependents Remove Arrows Show Formulas Calculate Now Error Checking . watch Calculation Calculate Sheet Window Options nsert AutoSum Recently Financial Logical Text Date &Lookup & Math & More Used -Time ReferenceTrig FunctionsManager Time-Reference- Trig. Functions . Manager Remove ArrowsEvaluate Formula ?Evaluate Formula Function Library Formua Auditing 5 Altamonte Springs 6 Central Orlando 7 Caselberry 8 Kissimmee 9 Lake Mary 10 Mount Dora 11 St. Cloud 12 13 14 2015 Admission Fee: 15 16 Total Attendees (2011-2015): 17 Total Locations: 18 19 7% $ 36,79 .65 $47,301.28 33% $ 169,979.15 $203,715.36 12% $ 63,800.00 $ 76,925.48 6% $ 31,900.00 $ 41,583.12 14% $ 71,790.95 $88,174.02 11% $ 56,590.60 $69,893.57 17% $ 90,707.65 $106,215.52 $521,565.00 $ 633,808.35 1580 2109 98 2247 2307 9683 10204 10657 2422 60 453 4580 48791054952 40(952) 150 4501 1,601 2568 11190 11861 4200 4452 2100 2226 4726 5010 3949 6330 34,335 36,395 7873 8145 83% 83% 2641 2598 1850 938 2325 2542 2900 4501 764 3320 3548 5311 5687 Total Attendance 26,825 28,851 30,678 30,78432,700 81% 81% 85% 3647 687 4873 4998 531 3879 3764 3725 376 5971 $ 15.95 City Name: Kissimmee 2015 Percentage: 149,838 Profit from Admission - Goal 80% 2015 Statistics