Question
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
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 XLOOKUP function, with the value retrieved by a VLOOKUP using the EventDetails named range as the lookup_value, the range B5:B8 as the lookup_array, and the range A5:A8 as the return_array. Use an IF function so that the discount only applies to board members. Format the result as Percentage with 0 decimal places. Copy the formula down through J30. 15
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 K30. 12
\begin{tabular}{|l|l|l|lr|} \hline \multicolumn{1}{|c|}{ EventID } & \multicolumn{1}{|c|}{ EventName } & \multicolumn{1}{c|}{ EventType } & RegistrationFee \\ \hline & 2019 Benchmarking Conference & & & \\ EVNT-0037 & Attendee & Annual Conference & $ & 120.00 \\ \hline EVNT-0012 & January HR Peer Networking & Peer Networking & $ & 180.00 \\ \hline EVNT-0042 & Toyota Plant Tour & Plant Tour & $ & 250.00 \\ \hline EVNT-0022 & Marsh Bellofram Plant Tour & Plant Tour & $ & 190.00 \\ \hline EVNT-0017 & Human Resource Professionals & Peer Networking & $ & 110.00 \\ \hline EVNT-0032 & State of the Industry & Survey/Study & $ & 180.00 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started