Formulas

[ssrvant]

I have a simple formula

A1 = 2
A2 = 3

In Cell A3 I want to put this formula:

=A1+ A2

When I press enter, I should get 5 as my answer in Cell A3, but when I
press enter "=A1+ A2" is displayed in cell A3

any ideas?

ssrvant

 

[Dave Peterson]

Make sure the cell is not formatted as Text
(Format|Cells|number tab)
If you change the format, then reenter the formula.

Make sure you're not looking at formulas:
tools|Options|view tab|uncheck formulas

Make sure you didn't start your formula with a space character.

 

[ssrvant]

Thanks Dave. Worked Great

Ssrvant

Make sure the cell is not formatted as Text
(Format|Cells|number tab)
If you change the format, then reenter the formula.

Make sure you're not looking at formulas:
tools|Options|view tab|uncheck formulas

Make sure you didn't start your formula with a space character.