$$270\mathrm{.}00$

$$150\mathrm{.}00$

$$125\mathrm{.}00$

$$275\mathrm{.}00$

$$175\mathrm{.}00$

$$125\mathrm{.}00$

$$112\mathrm{.}50$

$$270\mathrm{.}00$

$$150\mathrm{.}00$

$$150\mathrm{.}00$

$$180\mathrm{.}00$

$$148\mathrm{.}50$

$$275\mathrm{.}00$

$$225\mathrm{.}00$

$$150\mathrm{.}00$

$$178\mathrm{.}20$

$$275\mathrm{.}00$

$$150\mathrm{.}00$

$$250\mathrm{.}00$

$$175\mathrm{.}00$

$$175\mathrm{.}00$

$$300\mathrm{.}00$

$$175\mathrm{.}00$

$$325\mathrm{.}00$

$(1\mathrm{.}3)$ Calculate the "Add$-$On

Total" for the first transaction.

Rooms with $3$ or more guests are required to pay the add$-$on fee.

Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests, number of nights and the room type.

Use the data in to look up the cost based on the room type.

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

If there 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.

$10$