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 with AI-Powered 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

Business Statistics In Practice

Authors: Bruce Bowerman, Richard O'Connell

6th Edition

9780073401836

Students also viewed these Accounting questions

Question

What is a measure of effect?

Answered: 1 week ago