Question: Task 1 - Text Functions for Cabin Amenities The boss wants the Current Rates sheet to indicate whether each cabin has a fireplace and/or a

Task 1 - Text Functions for Cabin Amenities The boss wants the Current Rates sheet to indicate whether each cabin has a fireplace and/or a hot tub. Columns G and H have been created to contain that data, but nobody knew how to make text functions, so the columns are empty. Good thing you work here now... Your task is to create formulas in G2:H60 of the Current Rates sheet that will analyze the content of B2:B61 and display either a "Yes" or nothing ("") to tell the user whether or not that cabin has a particular feature (fireplace for column G and hot tub for column H). Hint: this will require an IF, a SEARCH or FIND, and an IFERROR function. Here's a sample of the desired results: A B C D E F G H Cabin Off-Season Standard Number Cabin Description Weekly Rate Weekly Rate Bedrooms Bathrooms Fireplace Hot Tub 100 Standard 1 Bedroom, 1 Bath 361.00 425.00 1 101 Standard 1 Bedroom, 1 Bath with fireplace 382.00 450.00 1 Yes 102 Deluxe 1 Bedroom, 1 Bath with hot tub 488.00 575.00 1 Yes

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 Finance Questions!

The boss wants the Current Rates sheet to indicate whether each cabin has a fireplace and/or a hot tub. Columns G and H have been created to contain that data, but nobody knew how to make text...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

BSBFIM501: Assessment 2- Managing Budgets. I am so bad at this, and don't understand how to do any of this assessment. BSBFIM501 - Assessment 2 Task 1 - Sales Budget Part A (1) The Black Helmet Motor...

VIEW THE STEP-BY-STEP SOLUTION TO: Title: ABC Appliance Inherent Risk and Control Design Assessment Prepare Inherent Risks and Control Design Assessment. This course project/case... I.Title: ABC...

Grading Rubric Course: MT460 Unit: 7 Points: 45 _________________________________________________ Unit 7: Corporate Social Responsibility and Business Ethics Case Study Analysis Paper: Prepare a case...

Please help, this is actually due today and the person who said they would answer this question that was initially due last night. Thank you for the help if possible. I need help with putting the...

This is a individual assignment, which is due on 27th of jan, wed, 1pm. Can u help me to do it? Financial Accounting 2 ACG 27, Study Period 4, 2015 Case Study for Annual Report Assignment The...

This exercise continues the Lawlor Lawn Service, Inc., situation from Exercise 19-32 of Chapter 19. Lawlor Lawn Service currently charges $100 for a standard lawn service and incurs $60 in variable...

Refer to the situation described inBE 11-2. Assume the machine was purchased on March 31, 2011, instead of January 1. Calculate depreciation expense for 2011 and 2012 using each of the following...

A _ _ _ _ _ _ _ _ is an order for a brokerage firm to buy a stock when the price rises to a specified level. Group of answer choices go order buy stop order sell stop order stop order

Give a brief history of mortgage-backed securities from their inception until the end of the financial crisis. Why were they originally invented? Why were they so profitable for banks? Do we have a...