On the EventAnalysis worksheet, in cell D4, enter a formula that will return Goal_Met if the number of registrants for the event meets or exceeds the goal for that event outlined in the cell range G4:H9, otherwise return Promote_Event. Copy the formula down through D9.

Esu = Q View Tell me Share 0 Comments Insert v v V 5 Delete $ %) Sort & Filter Ideas Sensitivity Format Find & Select fx K L M N 0 190 Iconrad Ledustries Inc. TGreene Tuenson VNT-0032 180.00 AutoSave OFF Hakes_Excel_Ch05_PS1_ResourceCenter Home Insert Draw Page Layout Formulas Data Review X Calibri (Body) 11 i = = ab Wrap Text General PUL! HP Paste BI U a. A v E Merge & Center .00 Conditional Format Cell .00 0 Formatting as Table Styles 139 X C D E F G H 1 Client Registrations 2 3 Board Member Discounts 4 Discount EventType 5 5% Annual Conference 6 5% Peer Networking 7 7% Plant Tour 8 10% Survey/Study 9 Registration Board Member 10 ContactID Firstname Lastname Board Member Company Name Date Registered EventID Guests Fees Discount 11 CN-0001 Charity Calhoun Yes SEA-LECT Plastics Corporation 11-Jan-19 EVNT-0037 3 $ 120.00 5% 12 CN-0003 Justin Wallace SMT LLC 17-Dec-18 EVNT-0037 1 $ 120.00 13 CN-0004 Sydnee Washington Southern Indiana Plastics 16-Feb-18 EVNT-0012 2 $ 180.00 14 CN-0005 Blake Bryan Yes 09-Feb-19 Southwest Mold Inc. yan EVNT-0037 1 $ 120.00 5% 15 CN-0006 Christine Tyson Yes SPI Industries Inc. 07-Apr-19 EVNT-0042 2$ 250.00 7% 16 CN-0007 Cassidy Lowe Steinwall Inc. 30-Mar-18 EVNT-0022 1 $ 190.00 4 17 CN-0008 Sloane Shaffer Stihl Incorporated 23-Jul-19 EVNT-0022 5$ 10 18 CM20Twine Oneil CN-00010 Wing BATO Yes 17.0hte Tasus Corporation - Alabama 17-Feb-18 EVNT-0042 Is 30 1$ 250.00 7% 10 CN . 19 0047 40 CN-00011 Avram Tasus Corporation - Texas 05-May-18 EVNT-0017 To 1 $ 110.00 20 20 ------ CN-00012 Adena Tun Team 1 Plastics 22-Aug-18 100 3 $ EVNT-0022 190.00 21 CN 00012 Barrett CN-00013 Barrett 400 Gonzales Yes 01-Apr-18 EVNT-0012 2 $ 180.00 5% CN Lleolie Imara The 22 430 CN-00014 Angelica Marquez Thogus Products Company 01-Nov-18 EVNT-0037 1 $ 120.00 23 CN 2015 12 430 CN-00015 Christine Hughes Trademark 14-Jun-19 EVNT-0037 1 $ 120.00 CH 10. ------ 24 400 CN-00016 Kevyn Lara Treemen Industries Inc 10-Mar-18 EVNT-0032 3 $ 180.00 Cluidi Tr 25 CN-00020 Heidi 40 Estes 4me Yes 21-Jul-18 Vantec Inc. Is EVNT-0017 1$ 110.00 5% ac CO2 26 CN-00022 Rebecca Venture Plastics 29. Now.ng 28-Nov-19 Is 190 EVNT-0022 1$ 190.00 A 27 2. M. CN-00023 Josephine Wabash Plastics Inc. 24-May-18 1$ 20 28 CN-00025 Fiona Oneil Yes GTM Plastics Inc. 01-Jul-18 EVNT-0012 3 $ 180.00 5% 29 CN-00026 Jeremy Sullivan GTR Enterprises 04-Feb-18 EVNT-0032 2 $ 180.00 30 CN-00027 Dora Delacruz Hansen Plastics Corporation 22-Jun-18 EVNT-0022 1 $ 190.00 31 32 33 34 35 36 37 38 39 40 Event Discount 5% 5% 5% 5% 5% 5% 5% ER 5% ER 5% ER 5% OK 5% 5% 5% Friends Discount 3% $ $ $ $ 1 $ $ 3%$ $ $ $ $ $ $ $ $ $ $ $ 3% $ $ $ Amount Due 313.20 114.00 342.00 108.00 440.00 180.50 874.00 874 00 10 220.00 404 104.50 CALEN 541.50 324.00 114.00 114.00 540.00 0 99.00 400 180.50 100 180.00 469.80 360.00 180.50 Henry Trademark Plastics Inc. 5% 5% 5% 5% ClientRegistration Event Details EventAnalysis + Ready + 100% AutoSave OFF Esu = Hakes_Excel_Ch05_PS1_Resource Center Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments X Calibri (Body) Insert v v = = 11 ab Wrap Text = PUL! HP General 28- O 5 Delete v Paste BI U av A. Merge & Center $ %) .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Ideas Format v Sensitivity B27 X fx B C D E F G H K L M N 0 i Event Details 2 3 4 5 6 EventID EventName EVNT-0037 2019 Benchmarking Conference Attendee EVNT-0012 January HR Peer Networking EVNT-0042 Toyota Plant Tour EVNT-0022 Marsh Bellofram Plant Tour EVNT-0017 Human Resource Professionals EVNT-0032 State of the Industry Event Type RegistrationFee Annual Conferences 120.00 Peer Networking $ 180.00 Plant Tour $ 250.00 Plant Tour $ 190.00 Peer Networking $ 110,00 Survey/Study $ 180.00 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 ClientRegistration EventDetails EventAnalysis + Ready + 100% AutoSave OFF Esu = Hakes_Excel_Ch05_PS1_Resource Center Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Body) v Insert v 11 i = = = a Wrap Text General LU 28-Ou 8 Delete v Paste BI U v Av Merge & Center $ % ) .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Ideas Format v Sensitivity A D4 X fx B C D E F G H I. L . N 0 P Q R S T U V W 1 2 3 Action Bonus 5 EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study 6 7 Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 Total Registrants 23 66 27 38 21 24 8 9 10 11 12 13 14 15 16 17 Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ $ Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $ 160.00 $ 180,00 $ 200.00 $ 220.00 160.00 $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $ 160.00 $ 180.00 $ 200.00 18 $ S Annual Conference Peer Networking Plant Tour Survey/Study Promote Event 20 25 30 35 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $ 110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $90.00 $ 110.00 $ 130.00 $ 150.00 un $ 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 ClientRegistration EventDetails EventAnalysis + Ready B + 100%