Please help.
I have a spreadsheet that just has a simple total formula in the bottom line.
However for some reason the formula doesnt put a value in the cell instead it appears to be blank.
You can see the formula in the formula bar but nothing appears in the cell.
(i have checked tools -options-calculation) and also that the text colour is not the same as the background colour).
If i try copying the formula left, even though the cells referenced in the formula change the total will come out as the first column.
I hope i have explianed things properly.
I would be grateful of any suggestions on this matter please.
Regads
I have a spreadsheet that just has a simple total formula in the bottom line.
However for some reason the formula doesnt put a value in the cell instead it appears to be blank.
You can see the formula in the formula bar but nothing appears in the cell.
(i have checked tools -options-calculation) and also that the text colour is not the same as the background colour).
If i try copying the formula left, even though the cells referenced in the formula change the total will come out as the first column.
I hope i have explianed things properly.
I would be grateful of any suggestions on this matter please.
Regads