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 .