Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 J 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 A:B on the ClientRegistration worksheet as the array and the result of the VLOOKUP as the lookupvalue for the MATCH function needed for the rownum 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 decimal places.
Copy the formula down through J
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