I have a spreadsheet for a Profit and Loss (see attached). When I create the formula in the first cell, I get the correct value. When I then right click and drag down to fill the column with the same formula, the cell references change – as I expected – but the value of the first cell is now showing in each cell. If I click on the next cell and then click on the formula in the editing area, the value changes to what it should be. So I have to do that for all the cells.
Why is it doing that and what can I do to stop it so that I see the correct value?
