Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help! It's for Excel. I just need help on the formulas. Calculate the number of nights for the first trartsaction. 0 Copy and paste

Need help! It's for Excel. I just need help on the formulas.

image text in transcribed
Calculate the number of nights for the first trartsaction. 0 Copy and paste the formula down the column to calculate the days for the other transactions. Calcdate the \"Room Total" for the first transaction. 0 Use an IF function to calculate a 10% discount for any stay greater than or equal to 7. 0 Copy and paste the function down the column to calculate the room total for the other transactions. Calculate the \"Add-0n Total" for the first transaction. 0 Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests and the room type. Use the data in P4:Q6 to lookup the cost based on the room type. The add-on fee is per person per night. Ifthere is no add-on fee display a zero (0) in the cell. Copy and paste the function down the column to calculate the add-on total for the other transactions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

College Accounting A Contemporary Approach

Authors: David Haddock, John Price, Michael Farina

5th Edition

126078035X, 978-1260780352

More Books

Students also viewed these Accounting questions

Question

What was the first language you learned to speak?

Answered: 1 week ago

Question

4. What is the goal of the others in the network?

Answered: 1 week ago

Question

2. What we can learn from the past

Answered: 1 week ago