Hi there,

I thought I'd have a sound knowledge of Excel but recently I am facing some strange difficulties. One is the following: I have a well-working formula, which I need to edit (e.g. take out one cell in a row of cells of which I have taken the average). When I delete the cell name an hit enter, the result of the calculation is no longer shown. Instead, I see the formula as displayed in the cell where the calculation result should be (and has been before editing). The formula is correct in syntax. No mistakes for sure.

I somehow solved the problelm some days ago, but I don't really remeber how... I'd like to know the reason for this happening, so that I can nip it in the bud and avoid the mistake in the first place.

Thanks in advance!

AF