Try checking your automatic calculation settings. ToolsOptionsCalculation.
Make sure Automatic is selected.

Or use F9 to calculate if you want it on manual.

Rhos


"Amy" wrote:

On several occasions lately I've had the misfortune of my spreadsheet
refusing to treat a formula as a formula. Instead it shows me the formula.
i.e. "=A2+A4" instead of "16". What causes this??? How do I avoid it?

Also, when the formula does work, I'm having an issue when I drag the
formula to other cells that it doesn't process unless I manually go into that
cell and hit enter. The formula reads correctly, but the result is the same
that was in the first cell until I click in the cell and hit enter. (This is
not a relative/absolute reference issue)

If these ring a bell to anyone...please help!!