1 2 Calculate the Room otal for the first transaction Use an IF function to calculate a 1 0 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

Question

1   2 Calculate the  Room  otal  for the first transaction  Use an IF function to calculate a 1 0   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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

$1.2$ Calculate the "Room "otal" 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.

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Expert Oracle Database Architecture