A
Amy
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!!
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!!