Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

 

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 Cabin Number Cabin Description 100 Standard 1 Bedroom, 1 Bath 101 Standard 1 Bedroom, 1 Bath with fireplace 102 Deluxe 1 Bedroom, 1 Bath with hot tub 1 2 3 4 E C D Standard Off-Season Weekly Rate Weekly Rate Bedrooms Bathrooms Fireplace 361.00 425.00 382.00 450.00 488.00 575.00 F 1 1 1 G 1 1 Yes 1 H Hot Tub Yes

Step by Step Solution

3.41 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

To create the formulas in columns G and H of the Current Rates sheet you can use a combination of th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Government and Not for Profit Accounting Concepts and Practices

Authors: Michael H. Granof, Saleha B. Khumawala

6th edition

978-1-119-4958, 9781118473047, 1118155971, 1118473043, 978-1118155974

More Books

Students also viewed these Finance questions