Question: 1 . 2 Calculate the Room Total for the first transaction. Use an IF function to calculate a 1 0 % discount for any stay

1.2 Calculate the "Room Total" for the first transaction.
Use an IF function to calculate a 10% discount for any stay greater than or equal to 7 nights.
Copy and paste the function down the column to calculate the room total for the other transactions.
Calculate the "Add-On
1.4 The manager would like
 1.2 Calculate the "Room Total" for the first transaction. Use an

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