Thread: Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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