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