openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: I'm sure it's very simple!
Date Mon, 04 Mar 2013 05:45:35 GMT
At 11:00 03/03/2013 -0800, Nancy Street wrote:
>Hello, I would appreciate your help and I'm sure the answer is very 
>simple...but I've been searching for a day and a half...trying to 
>google, and FAQ.. to no avail.
>QUESTION:  In a spreadsheet, Rather than displaying the ANSWER... 
>the cell will only give the formula.  I cannot get any answers ONLY formulas.
>Example:  A1 = 200, A2 = 400, A3 = 500.....  in cell A4 I put 
>=sum(A1:A3) enter.... in cell A4... the answer is =)sum(A1:A3).... I 
>want the REAL answer of 11.

Go to Tools | Options... | Calc | View | Display.  Is 
there a tick in the Formulas box?  If so, remove it.

Alternatively, it may be that you have entered your formula slightly 
wrongly, so that it has been interpreted as a text string and not a 
formula.  One example of this is entering a  leading space - before 
the equals sign.

I trust this helps.

Brian Barker

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message