[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
bgabbo
Newbie

Joined: 20 Aug 2007
Posts: 3

 Posted: Mon Aug 20, 2007 6:31 pm    Post subject: problem with calculations Getting an error 503 code with simple calculations. Such as cell d3 equals d2/d1. Any help would be appreciatied.
Sliderule
Super User

Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun

Posted: Mon Aug 20, 2007 6:54 pm    Post subject:

bgabbo:

According to the Calc Help:
 Calc Help wrote: 503 Invalid floating point operation Division by 0, or another calculation that results in an overflow of the defined value range.

Division by zero is not allowed. If you try it with an electronic calculator . . . same is true.

You could, if you want, perform a check ( IF ) to handle the situation. For example, in Cell D3:
 Code: =IF(D1 = 0; 0; D2 / D1)

I hope this helps, please be sure to let me / us know.

Sliderule
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6733

Posted: Tue Aug 21, 2007 3:14 am    Post subject: Re: problem with calculations

 bgabbo wrote: Getting an error 503 code with simple calculations. Such as cell d3 equals d2/d1. Any help would be appreciatied.

To follow up on Sliderule's post, error 503 may also indicate that you're trying to divide by a character variable. It is possible that you're referencing a text cell.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
bgabbo
Newbie

Joined: 20 Aug 2007
Posts: 3

 Posted: Tue Aug 21, 2007 3:37 am    Post subject: I get the error code when d2 is 600 and d1 is 10. The answer should be 60, but I get the error 503 code.
David
Super User

Joined: 24 Oct 2003
Posts: 5668

Posted: Tue Aug 21, 2007 5:37 am    Post subject:

 bgabbo wrote: I get the error code when d2 is 600 and d1 is 10. The answer should be 60, but I get the error 503 code.

You will still get a division by zero if the data in D1 is somehow formatted as text. Calc will think that you are dividing by some text [even if it looks like a number], which is assigned a numerical value of zero.

David.
thomasjk
Super User

Joined: 16 Dec 2005
Posts: 2308

 Posted: Tue Aug 21, 2007 7:19 am    Post subject: Is you formula actually d2/d1. It should be =d2/d1. I get 0 if I add and ' before the 600 and Err:503 of add an ' in front of the 10. You are trying to divide by using a text not numerical value. Click in the cell with 10 and see it appears in the edit box as '10. If it does pres F2 to edit and delete the '.
bgabbo
Newbie

Joined: 20 Aug 2007
Posts: 3

 Posted: Wed Aug 22, 2007 4:12 am    Post subject: thank you
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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