I need some help with my excel homework and it's a lot to take in

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. 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.

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.

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.

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.

In cell M11, enter a formula that will calculate the total amount due after discounts have been applied. Incorporate an IFERROR function to return a blank value ("") if formula returns an error. Format the result as Accounting and copy the formula down through M34.

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.

First Resource offers a bonus to the coordinator for each event. The bonus amount is based on the event type and the number of registrants. In addition, there are different amounts awarded if the registration goal has been met or not. Create a Goal_Met named range for cells H14:L17 and a Promote_Event named range for cells H21:L24.

In cell E4 enter an INDEX function that incorporates the INDIRECT function for the array argument to retrieve the bonus amount the event coordinator will receive. Format the result as Accounting and copy the formula down through E9.

Client Registrations Board Member Discounts Discount EventType 5% Annual Conference 5% Peer Networking 7% Plant Tour 10% Survey/Study ContactID Firstname Lastname BoardMember Company Name DateRegistered EventID Guests "Registration Fees" "BoardMember Discount" "Event Discount" "Friends Discount" "Amount Due" CN-0001 Charity Calhoun Yes SEA-LECT Plastics Corporation 11-Jan-19 EVNT-0037 3 CN-0003 Justin Wallace SMT LLC 17-Dec-18 EVNT-0037 1 CN-0004 Sydnee Washington Southern Indiana Plastics 16-Feb-18 EVNT-0012 2 CN-0005 Blake Bryan Yes Southwest Mold Inc. 09-Feb-19 EVNT-0037 1 CN-0006 Christine Tyson Yes SPI Industries Inc. 07-Apr-19 EVNT-0042 2 CN-0007 Cassidy Lowe Steinwall Inc. 30-Mar-18 EVNT-0022 1 CN-0008 Sloane Shaffer Stihl Incorporated 23-Jul-19 EVNT-0022 5 CN-00010 Wing Oneil Yes Tasus Corporation - Alabama 17-Feb-18 EVNT-0042 1 CN-00011 Avram Conrad Tasus Corporation - Texas 05-May-18 EVNT-0017 1 CN-00012 Adena Henry Team 1 Plastics 22-Aug-18 EVNT-0022 3 CN-00013 Barrett Gonzales Yes Technical Industries Inc. 01-Apr-18 EVNT-0012 2 CN-00014 Angelica Marquez Thogus Products Company 01-Nov-18 EVNT-0037 1 CN-00015 Christine Hughes Trademark Plastics Inc. 14-Jun-19 EVNT-0037 1 CN-00016 Kevyn Lara Treemen Industries Inc 10-Mar-18 EVNT-0032 3 CN-00020 Heidi Estes Yes Vantec Inc. 21-Jul-18 EVNT-0017 1 CN-00022 Rebecca Greene Venture Plastics 28-Nov-19 EVNT-0022 1 CN-00023 Josephine Henson Wabash Plastics Inc. 24-May-18 EVNT-0032 1 CN-00025 Fiona Oneil Yes GTM Plastics Inc. 01-Jul-18 EVNT-0012 3 CN-00026 Jeremy Sullivan GTR Enterprises 04-Feb-18 EVNT-0032 2 CN-00027 Dora Delacruz Hansen Plastics Corporation 22-Jun-18 EVNT-0022 1

EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $120.00 EVNT-0012 January HR Peer Networking Peer Networking $180.00 EVNT-0042 Toyota Plant Tour Plant Tour $250.00 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $190.00 EVNT-0017 Human Resource Professionals Peer Networking $110.00 EVNT-0032 State of the Industry Survey/Study $180.00