Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed4) 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operational Auditing Principles And Techniques For A Changing World

Authors: Hernan Murdock

2nd Edition

1000388247, 9781000388244

More Books

Students also viewed these Accounting questions

Question

What is the importance of master data management?

Answered: 1 week ago

Question

Discuss cross-cultural differences in perception

Answered: 1 week ago

Question

Compare and contrast families and family roles across cultures

Answered: 1 week ago

Question

Compare and contrast sex and gender roles across cultures

Answered: 1 week ago