openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian and Nancy Street <br5...@telus.net>
Subject I'm sure it's very simple!
Date Sun, 03 Mar 2013 19:00:23 GMT
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.  

HELP!

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.  

Thank you, Nancy
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message