Change the formula in the cell D27 of the SALES worksheet, so that if it is copied to the cell range D27:K31, it calculates correctly the hypothetical turnover for each way of payment. Apply the formula to this cell range.