At the SALES worksheet, change the formula to the cell D27 so that if copied or filled in automatically to all cells of the cell range D27:Ê31, it should calculate correctly the hypothetical turnover for each way of payment. Lastly, apply this formula to this cell range.