Question: Excel Module 10 Case 1 Q6 I cannot understand the formula needed to come up with an answer that will work with various number of

Excel Module 10 Case 1 Q6

I cannot understand the formula needed to come up with an answer that will work with various number of attendees. The formula I came up with only works when the number of attendees are 0, 50,100,150, & 200.

Here is what I used: =vlookup(number_of_attendees,D6:E10,2,False)

Excel Module 10 Case 1 Q6 I cannot understand the

Please help!

6. The company must rent a conference room large enough to accommodate the number of attendees. The lookup table in the range D5:E10 contains the room charges for seminars of 0 to 50 people, 50 to 100 people, 100 to 150 people, 150 to 200 people, and beyond 200 people. For example, a room that fits 0 to 50 people will cost the company $400. In cell B23, calculate the room rental cost by looking up the room rental fee based on the number of attendees to the seminar. (Hint: Use the VLOOKUP function with an approximate match lookup.)

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 General Management Questions!

Excel Module 10 Case 1 Q6 I cannot understand the formula needed to come up with an answer that will work with a various numbers of attendees. The formula I came up with only works when the number of...

I am having trouble creating the formulas for number 11 and 13. Excel File Edit View Insert Format Tools Data Window Help Seminar Budget.xlsx Q Search Sheet cut AutoSum A | Fill Calibri Light Wrap...

5 calculation questions, 5 concept questions. Prefer answers in word format. MGMT 613 - Financial Management Module 10 Questions 1. LTC and NPV are two methods for valuating a long term capital...

In January 2010, Gary Haberland, president and founder of GENICON, a U.S.-based firm that manufactured and distributed medical devices used in laparoscopic surgery, sat at his desk poring through...

Hope you remember me from earlier in the week.... you needed some additional information to answer question number 1 and question number 2. I've confirmed that the two things being compared is Lowest...

1. Build a Balanced Scorecard for the unit of the organization for which you work, or have worked. Unless you are in senior management, focus on the unit with which you are most familiar rather than...

I need to get help with this case study PwC Case Studies in Taxation, 2013, PwC, LLP FLATIRONS, INC. Flatirons, Inc. (dba Flatirons Flapjacks Caf) specializes in unique breakfast and brunch menus and...

Requirements 1. The report is at least five pages long, and please follow APA formatting. 2. Include your name, section, and student ID on the title page. 3. In the report, you should include the...

Module 3 Case UTILITY ETHICS Background In the Module 3 Case, we will use the Utility Test to inform our understanding of the Enron case study. Required Reading Visit the library, and locate the...

Requirements 1. The report is at least five pages long, and please follow APA formatting. 2. Include your name, section, and student ID on the title page. 3. In the report, you should include the...

Factory A can produce a maximum of 560 tons of sugar, factory B can produce a total of 1040 tons while factory C can supply up to a maximum of 1440 tons of sugar. The output from the various...

You are the governor of the Bank of Japan. You have been tasked with accomplishing (or at least providing broader guidance on) two key goals: First, you are tasked with stabilizing real GDP. Real GDP...

The rate on a U . S . Treasury bond is likely to be Choose your answer here lowerhigher than the rate on a comparable corporate bond because the risk associated with the U . S . Treasury is perceived...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...