I need help on putting these formulas in excel I would appreciate if you can make it so I am able to copy and paste the formula into excel thank you.

Registration fees, located in the EventDetails table, are based on a particular Event's EventID. Registration fees must be paid for each person attending the event. 3-On the ClientRegistration worksheet, in cell I11 enter a VLOOKUP function to retrieve the registration fee from the EventDetails named range for the EventID in cell G11. Multiply the value retrieved by the number of guests in cell H11. Incorporate an IFERROR function to return a blank value if the VLOOKUP function returns an error. Format the value as Accounting and copy the formula down through I34.

4-

Attendees who are also board members receive a discount off the registration fees. The discount amount varies based on the type of event. In cell J11 enter a formula that will return the discount amount if the registrant is a board member and return a blank value ("") if they are not. Use a VLOOKUP function to retrieve the EventType from the EventDetails named range. Use an INDEX function, with the cell range A5:B8 on the ClientRegistration worksheet as the array and the result of the VLOOKUP as the lookup_value for the MATCH function needed for the row_num argument. Use an IF function so that the discount only applies to board members and all others will display as a blank ("") Format the result as Percentage with 0 decimal places. Copy the formula down through J34.

5-

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.

6-

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.

9 Registration Fees Board Member Discount Event Discount Friends Discount Guests Amount Due 3 1 2 Date Registered 11-19 17-Dec 18 16 Feb-18 + 09-FA-19 07 Apr 19 30-Mar-18 23 Jul 19 17+eb-18 1 Z 1 5 1 1 05-Mar15 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 3 2 1 1 Eventi EVNT-0037 EVNT-0037 EVNT-0012 FUNT-0017 EVNT 0042 EVNT-0022 EVNT 0022 - EVNT-0042 FVNT-0017 EVNT-0022 EVNT-0012 EVNT 0037 EVNT-0037 EVNT-0032 EVNT-2017 EVNT-0022 EVNT 0032 EVNT-0012 EVNT-0032 EVNT-0022 1 22 Aug 18 01-Apr-18 01 Nav 18 14-Jun-19 10-Mar-18 21.Jul 18 28-Nov-19 24 May 18 01-Jul-18 04-Feb-18 22-Jun-18 3 1 1 1 1 3 2 1 39 EventDet... x fx EVNT-0037 B C D E F G H J i Event Details 2 3 EventID EventName EventType RegistrationFee 4 EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $ 120.00 5 EVNT-0012 January HR Peer Networking Peer Networking $ 180.00 6 EVNT-0042 Toyota Plant Tour Plant Tour $ 250.00 7 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $ 190.00 8 EVNT-0017 Human Resource Professionals Peer Networking $ $ 110.00 9 EVNT-0032 State of the Industry Survey/Study $ 180.00 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 42 Event Analysis Action Bonus Eventi EVNT 0037 EVNT-0012 FVNT-0042 EVNT-0022 EVNT-0017 EVNT 0032 Event Type Annual Conference Peer Networking Plan Tour Plant Tour Peer Networking Survey/Study TotalRegistrants 23 66 27 38 21 24 Registration Goals Eventi RegistrationGo EVNT 0037 20 EVNT-00.2 70 FVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT 0032 25 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 $ 150.00 $ 200.00 $ Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ $ Promote Event 20 25 30 35 40 100.00 $ 120.00S 140.00 $ 160.00 $ 180.00 $0.00 $ 110.00 $ 130,00 $ 150.00 $ 170.00 110,00 $ 130,00 5 150.00 $ 170 00 $ 190,00 70.00 $ 99.00 $ 110.00 $ 130.00 $ 150.00 $ $ 9 Registration Fees Board Member Discount Event Discount Friends Discount Guests Amount Due 3 1 2 Date Registered 11-19 17-Dec 18 16 Feb-18 + 09-FA-19 07 Apr 19 30-Mar-18 23 Jul 19 17+eb-18 1 Z 1 5 1 1 05-Mar15 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 3 2 1 1 Eventi EVNT-0037 EVNT-0037 EVNT-0012 FUNT-0017 EVNT 0042 EVNT-0022 EVNT 0022 - EVNT-0042 FVNT-0017 EVNT-0022 EVNT-0012 EVNT 0037 EVNT-0037 EVNT-0032 EVNT-2017 EVNT-0022 EVNT 0032 EVNT-0012 EVNT-0032 EVNT-0022 1 22 Aug 18 01-Apr-18 01 Nav 18 14-Jun-19 10-Mar-18 21.Jul 18 28-Nov-19 24 May 18 01-Jul-18 04-Feb-18 22-Jun-18 3 1 1 1 1 3 2 1 39 EventDet... x fx EVNT-0037 B C D E F G H J i Event Details 2 3 EventID EventName EventType RegistrationFee 4 EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $ 120.00 5 EVNT-0012 January HR Peer Networking Peer Networking $ 180.00 6 EVNT-0042 Toyota Plant Tour Plant Tour $ 250.00 7 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $ 190.00 8 EVNT-0017 Human Resource Professionals Peer Networking $ $ 110.00 9 EVNT-0032 State of the Industry Survey/Study $ 180.00 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 42 Event Analysis Action Bonus Eventi EVNT 0037 EVNT-0012 FVNT-0042 EVNT-0022 EVNT-0017 EVNT 0032 Event Type Annual Conference Peer Networking Plan Tour Plant Tour Peer Networking Survey/Study TotalRegistrants 23 66 27 38 21 24 Registration Goals Eventi RegistrationGo EVNT 0037 20 EVNT-00.2 70 FVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT 0032 25 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 $ 150.00 $ 200.00 $ Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ $ Promote Event 20 25 30 35 40 100.00 $ 120.00S 140.00 $ 160.00 $ 180.00 $0.00 $ 110.00 $ 130,00 $ 150.00 $ 170.00 110,00 $ 130,00 5 150.00 $ 170 00 $ 190,00 70.00 $ 99.00 $ 110.00 $ 130.00 $ 150.00 $ $