OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

sum of 20,30,40=##

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Mi-Ani
General User
General User


Joined: 29 Oct 2003
Posts: 34
Location: Silicon Valley, CA

PostPosted: Wed Dec 03, 2003 6:11 pm    Post subject: sum of 20,30,40=## Reply with quote

I am sure it has to do with a set up on the SpreadSheet.
when I insert numbers in 3 or 4 cells, such as:
A1=20
B1=30
C1=40, and wish to add these numbers on cell D1,
I get ## in that cell , or the the formula itself, instead of the sum amout. What do I need to do to correct this problem?
Back to top
View user's profile Send private message
Sue
Power User
Power User


Joined: 22 Nov 2003
Posts: 74
Location: New Zealand

PostPosted: Wed Dec 03, 2003 9:30 pm    Post subject: Reply with quote

### usually means that the cell is too narrow to show all the result. Make the cell larger and you should be OK. Make some filled cells smaller and watch the numbers change to ## Smile
Back to top
View user's profile Send private message AIM Address
Mi-Ani
General User
General User


Joined: 29 Oct 2003
Posts: 34
Location: Silicon Valley, CA

PostPosted: Thu Dec 04, 2003 8:20 am    Post subject: Reply with quote

This one was one of the first things I tried. It still remains ###, or the cell is filled with the the formula itself such as =SUM(A1;B1;C1)
Back to top
View user's profile Send private message
astefos
Guest





PostPosted: Thu Dec 04, 2003 9:41 am    Post subject: Reply with quote

do u have to have the cell type set to text or sthing? your formula works fine with me.
Back to top
Guest






PostPosted: Thu Dec 04, 2003 9:42 am    Post subject: Reply with quote

"do you happen to have" that is...
Back to top
Sue
Power User
Power User


Joined: 22 Nov 2003
Posts: 74
Location: New Zealand

PostPosted: Thu Dec 04, 2003 11:02 am    Post subject: Reply with quote

Try Options / Spreadsheet / View ~ Then Untick Display Formulas, it might be a good idea to check that the other options are set to what you want too.
Hope that sorts it out for you. Smile
Back to top
View user's profile Send private message AIM Address
The Liquidator
Super User
Super User


Joined: 27 Feb 2003
Posts: 1368
Location: Manchester, UK

PostPosted: Thu Dec 04, 2003 3:41 pm    Post subject: Reply with quote

Hi

What are you actually typing? Putting commas in when I had a go came up with #NAME?

Simplest is to simply type =a+b+c and you get the result. Alternatively if you are working in adjacent cells hit the autosum button.

Perhaps I'm wrong, but have you just moved from Excel?

Ian
Back to top
View user's profile Send private message
Mi-Ani
General User
General User


Joined: 29 Oct 2003
Posts: 34
Location: Silicon Valley, CA

PostPosted: Thu Dec 04, 2003 6:20 pm    Post subject: Reply with quote

It had to do with the setting , as Sue had suggested. Now it seems to be working fine.
Never used Excel in my life. Moving from QP10, made by Mrs. Corel
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group