9 Calculate the discount total for the Paradise Club for
5.000
One Double rooms for Friday night in cell B27. To enter the formula, multiply the number of Paradise Club One Double rooms rented on Friday by the Standard Rate for a One Double room by the Paradise Club discount. The result of the formula will be a negative number to reflect the discount total.
10 Calculate the Group discount total in cell B28. To do so,
5.000 multiply the Standard Rate for a One Double room by the number of Group Discount rooms sold for Friday night by the Group Discount.
11 Calculate the Comp discount total in cell B29. Multiply
5.000 the Standard Rate for a One Double room by the number of Comp Discount rooms sold for Friday night by the Comp Discount.
12 Select cell range B26: B29. Click and hold the fill handle 5.000 and then expand the selection to include B26: G29.