Question: In J 1 1 , enter a formula that will return the discount amount if the restrant is a board member, and return a blank

In J11, enter a formula that will return the discount amount if the restrant is a board member, and return a blank balue "" if they are not. Use a Xlookup functionm with the value retrieved by a Vlookup using the event details named range as the lookup value, the range B5:B8 as the lookup array and the range A5:a8 AS THE RETURN ARRAY

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

I need some help with starting my Excel homework Start Excel. Download and open the file named Excel_Ch05_PS1_ResourceCenter.xlsx. Grader has automatically added your last name to the beginning of...

Q:

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

Q:

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

Q:

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

Q:

Please complete steps g and h. work is related to excel. Previous steps are listed if needed to understand g and h. A formula is needed for cell m11 on client registration worksheet and a formula for...

Q:

On the Transactions worksheet, in cell 110, replace the static value by entering a VLOOKUP function to fetrieve the Item's price from the Product_List table and then multiply it by the quantity to...

Q:

I need answers for 7-11. Grader - Instructions Excel 2019 Project Step Instructions Points Possible 6 1.8 Another rewards program that Aleeta is considering includes a way for non-club members to...

Q:

First Resource is offering a 5% discount off registration fees for all 12 EventTypes except for Survey/Study. In cell K11 enter a formula that will return 0.05 if the event is NOT a Survey/Study,...

Q:

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

Q:

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

Q:

The trial balance for Treasure Hunt Exploration Company, Inc. does not balance. The following errors were detected: a. The cash balance is overstated by $5,000. b. Rent expense of $340 was...

Q:

What Is the Best Way to Position? Marketers have different views of how to position a brand. Some value structured approaches such as the competitive positioning model described in the chapter, which...

Q:

Val decided to purchase a wireless headset priced at $ 1 5 0 because of a special offer from the manufacturec. By sending proof of purchase and the receipt to the manufacturer, she could recelve a $...

Q:

Which chapter in bankruptcy can only be filed by people? Group of answer choices Chapter 13 Chapter 7 Chapter 9 Chapter 11