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

PROBLEM WITH MULTIPLICATION FORMULA

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
benlenton
Newbie
Newbie


Joined: 14 Jun 2009
Posts: 2

PostPosted: Sun Jun 14, 2009 3:04 am    Post subject: PROBLEM WITH MULTIPLICATION FORMULA Reply with quote

Hi there

I have a problem with a simple multiplication formula which is not functioning.

In one cell (e.g. B1) I insert a figure e.g. 5000
In the other cell (e.g. B2) I insert a multiplier e.g. 20% or 0.2
In the third cell I insert the formula as follows:

=B1*B2

when the result should be 1000, it is returning as zero. I can't work out why because on all other sheets I am working on there is no problem at all with this formula.

Does anyone know the reason for this?

Thanks

Ben
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jun 14, 2009 4:52 am    Post subject: Reply with quote

Your number format locale of the "0.2" value is set to "Default" which defaults to the application-wide number locale in the language options, which itself defaults to the language and country of your operating system. The program can not read your mind. The OS locale is the only way to get a hint about the local context you are using for your numbers.
Let's say, your locale is French, German, Swedish or something, then "0.2" is text rather than a number, but "0,2" is numeric.

If this is not the reason, then you enforced any one of the involved numbers to be text. Ususally this happens on import if the source data are explicitly declared as text or with messed up Excel files where recent versions of Excel try to evaluate numeric text values (which may yield wrong values at times).
Ctrl+F8 shows numbers in blue font, text in black.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
benlenton
Newbie
Newbie


Joined: 14 Jun 2009
Posts: 2

PostPosted: Sun Jun 14, 2009 5:54 am    Post subject: Reply with quote

Great, thanks very much for the explanation. I have sorted it now (I think!).

Ben
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