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.$

$2.$ Calculate the "Add$-$On Total" for the first transaction.

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 P$4$:Q$6$ to determine the cost based on the room type.

The add$-$on fee is per person per night.

If no add$-$on fee exists, display a zero $(0)$ in the cell.

$3.$ The manager would like some details on revenue and taxes.

Calculate the "Total With Tax" for the first transaction.

Copy and paste the formula down the column to calculate the total with tax for the other transactions.

In cell Q$12,$ calculate the "Total Revenue Before Tax".

In cell Q$13,$ calculate the "Total Tax Collected."

Use the "Tax Rate" in cell Q$8$ and the "Total Revenue Before Tax" you calculated in Q$12$ to calculate the total tax collected.

$4.$ In cell Q$14,$ use a SUMIF function to calculate the "Total Revenue $3$ or $4$ Guests."

Reference the data in columns J and N in your function.

$5.$ The manager would like a quick way to see a guest's room total. Use the IFERROR, INDEX and MATCH functions to display the room total for the guest with the last name Vazquez.

If the function does not return a room cost, display the text $"$No Match" as a result.

$6.$ The manager would like to start creating a "Guest ID$"$ that can be used by the cleaning staff. In cell B$4,$ create a guest ID with the pattern: Guest Last Name Room: Room # of Guests. For example, if two guests with the last name of West stay in the Coolidge room, the guest id would be "West Room: Coolidge $2"$ without quotation marks.

Use the CONCAT $($or CONCATENATE$)$ function.

Reference the Guests Last Name, Room and # of Guests in your function.

Pay close attention to the spaces in the Guest ID$.$