$\backslash$table$[[3,,,$the,Audect iotal Total with If$],[3,2,$$$150\mathrm{.}00,$HNALUE!,$],[2,2,$$$325\mathrm{.}00,,],[8,2,$$$300\mathrm{.}00,,],[2,4,$$$150\mathrm{.}00,,],[6,1,$$$125\mathrm{.}00,,],[3,4,$$$275\mathrm{.}00,,],[1,2,$$$175\mathrm{.}00,,],[3,2,$$$125\mathrm{.}00,,],[7,4,$$$125\mathrm{.}00,,],[8,3,$$$300\mathrm{.}00,,],[1,2,$$$150\mathrm{.}00,,],[1,1,$$$150\mathrm{.}00,,],[7,3,$$$200\mathrm{.}00,,],[4,3,$$$148\mathrm{.}50,,],[1,4,$$$275\mathrm{.}00,,],[8,4,$$$250\mathrm{.}00,,],[2,2,$$$150\mathrm{.}00,,],[8,1,$$$198\mathrm{.}00,,],[5,4,$$$275\mathrm{.}00,,],[2,2,$$$150\mathrm{.}00,,],[3,4,$$$250\mathrm{.}00,,],[3,2,$$$175\mathrm{.}00,,],[2,1,$$$175\mathrm{.}00,,],[1,4,$$$300\mathrm{.}00,,],[2,2,$$$175\mathrm{.}00,,],[2,4,$$$325\mathrm{.}00,3,],[2,2,$$$325\mathrm{.}00,,],[4,1,$$$150\mathrm{.}00,,],[4,3,$$$250\mathrm{.}00,,],[4,2,$$$250\mathrm{.}00,,70]]$

schedule employees for the remodel.

$1\mathrm{.}1$ Calculate the number of

$1\mathrm{.}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.

$10$

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

$1\mathrm{.}4$ The manager would like

$1\mathrm{.}5$ In cell Q$14),$ use a SUMIF

$1\mathrm{.}6$ The manager would like a

$1\mathrm{.}7$ The manager would like to