| View previous topic :: View next topic |
| 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. |
|
| Back to top |
|
 |
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 |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| 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
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| 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. |
|
| Back to top |
|
|
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 '. |
|
| Back to top |
|
|
bgabbo
Newbie
Joined: 20 Aug 2007
Posts: 3
|
| Posted: Wed Aug 22, 2007 4:12 am Post subject: |
|
|
| thank you |
|
| Back to top |
|
|
|
