1. First Resource is offering a 5% discount off registration fees for all EventTypes except for Survey/Study. In cell K11 enter a formula that will return 0.05 if the event is NOT a Survey/Study, otherwise return a blank value (""). Use a VLOOKUP function to return the EventType from the EventDetails named range. Use a NOT function so that any event type other than Survey/Study will return TRUE. Use an IF function to return 0.05 for the value_if_true and "" for the value_if_false. Incorporate an IFERROR function to return a blank value if the VLOOKUP function returns an error. Format the result as Percentage with 0 decimal places and copy the formula down through K34.

2. First Resource also offers a 3% discount off registration fees if the registrant meets certain criteria. In cell L11, enter an IF function that will return 0.03 if the following criteria are met, otherwise return a blank value (""). If the registrant is a board member and had 3 or more people in the party OR the registrant has a total of 5 or more in their party. Format the result as Percentage with 0 decimal places and copy the formula down through L34.

Tell me Share Comments 28- O % Su Sort & Filter Ideas Sensitivity Find & Select L M N Friends Discount Amount Due CN-00019 Angelica Marquez Hughes Greene OO AutoSave OFF Hakes_Excel_Ch05_PS1_Resource Center Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 v AA = - ab Wrap Text General # Insert 5 Delete Paste B I 3 Merge & Center $ %) Conditional Format Cell Formatting as Table Styles ! Format J11 fx C D E G H I K 3 Board Member Discounts 4 Discount Event Type 5 5% Annual Conference 5% Peer Networking 7 7% Plant Tour 10% Survey/Study Registration Board Member Event 10 Contacted Firstname Lastname Board Member Company Name Date Registered Eventi Guests Fees Discount Discount 11 CN-0001 Charity Calhoun SEA-LECT Plastics Corporation 11-Jan-19 EVNT-00371 $ 120.00 12 CN-0003 Justin Wallace SMT LLC 17-Dec-18 EVNT-0037 1 $ 120.00 CNO 13 CN-0004 Sydnee Washington Southern Indiana Plastics 16-Feb-18 EVNT-0012 21 $ 180.00 CN-0005 Blake Bryan AT2022 Yes Southwest Mold Inc. 09-Feb-19 EVNT-0037 1 $ 120.00 ca 15 CN-0006 Christine Tyson Yes SPI Industries Inc. 07-Apr-19 EVNT-0042 2 $ 250.00 16 CN-0007 Cassidy Lowe Steinwall Inc. 30-Mar-18 EVNT-0022 1 $ 190.00 17 CN-0008 Sloane Shaffer 23-Jul-19 Stihl Incorporated Falle EVNT-0022 $ 190.00 18 CN-00010 Wing Oneil -12 1 Yes Tasus Corporation - Alabama 17-Feb-18 EVNT-0042 250.00 20 19 CN-00011 Avram Conrad INT onau Tasus Corporation - Texas 05-May-18 EVNT-0017 110.00 20 VI CN-00012 Adena Henry Team 1 Plastics hey EVNT-0022 22-Aug-18 S 190.00 - Plastics 21 za CN-00013 Barrett Nallet Gonzales 12 Technical Industries Inc. Pone 01-Apr-18 EVNT-0012 S 180.00 22 VIL E-0014 Thogus Products Company 01-Nov-18 EVNT-0037 S 120.00 23 21 CN-00015 Christine Trademark Plastics Inc. 14-Jun-19 EVNT-0037 120.00 24 CN-00016 Kevyn - -21 Lara Treemen Industries Inc reemen Indust 10-Mar-18 EVNT-0032 180.00 200.00 25 CN-00020 Heidi wa Estes Yes Vantec Inc 21-Jul-18 EVNT-0017 $ 110.00 - 0017 26 -120 -2012 CN-00022 Rebecca CINZA Venture Plastics 28-Nov-19 EVNT-0022 $ 20-NOV-19 190.00 27 CN-00023 Josephine Henson Wabash Plastics Inc. 24-May-18 EVNT-0032 $ 180.00 ? 28 20 CN-00025 Fiona Oneil Yes GTM Plastics Inc. 01-Jul-18 EVNT-0012 S 180.00 29 CN-00026 Jeremy Sullivan GTR Enterprises 04-Feb-18 EVNT-0032 $ 180.00 30 CN-00027 Dora Delacruz Hansen Plastics Corporation 22-Jun-18 EVNT-0022 11 s 190.00 31 32 33 34 35 36 37 38 39 ClientRegistration EventDetails EventAnalysis + Ready 100% OO AutoSave OFF BES Hakes_Excel_Ch05_PS1_Resource Center Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) Ci = 11 v AA # Insert ab Wrap Text General vyu Ou 5 5 Delete Paste B I DA 3 Merge & Center $ %) OOO Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity ! Format Find & Select B27 . fx B C D E F G T L N 0 i Event Details 2 3 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 Annual Conference Peer Networking plant Tour Plant Tour Peer Networking Survey/Study Registration Fee 120.00 180.00 250.00 $ 190.00 $ 110,00 $ 180.00 10 12 13 14 15 17 18 31 32 33 34 35 36 ClientRegistration EventDetails EventAnalysis + Ready 100% OO AutoSave Hakes_Excel_Ch05_PS1_Resource Center Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 v AA = # Insert ab Wrap Text General Ayu O 9 Delete Paste B I E Merge & Center $ % ) - Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format Find & Select - fx EventID B C D E F T J K L M N O P O R S U Event Analysis Total Registrants Action Bonus 23 66 EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 27 38 21 24 11 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 Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ Promote Event 20 29 30 100.00 $ 120.00 $ 140.00 90.00 $ 110.00 130.00 110.00 $ 130.00 150.00 70.00 $ 90.00 $ 110.00 30 40 $ 160,00 $ 180.00 $ 150.00 $ 170.00 $ 170.00 190.00 $ 130,00 $ 150.00 un 26 27 28 34 35 36 37 38 39 ClientRegistration EventDetails EventAnalysis + Ready 100%