Formulas
 

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

Formulas
 

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 wrote:

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

Formulas
 

Thanks Dave. Worked Great

Ssrvant
Dave Peterson wrote:
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 wrote:

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