Re: #DIV/0!
Often in regular business context a div/0 is defined to 0 because 0 is defined also as I do not know. Mathematically div/0 is defined as an enormous huge number of unknown size. In electronic signal theory, there is also a div/0 which is defined as ideal impulse with unlimited high. You see there the correct definition depends on its interpretation of the topic you use it. The correct way for resolving your issue if you know what the right definition is, should be the use of a if-claus. If (divisor = 0;;) I think you could use. Maybe I got the syntax wrong. Marcus <marcus.m...@wtnet.de> schrieb am Di., 27. Dez. 2016, 11:09: > Am 12/24/2016 06:00 AM, schrieb Robert Marshall: > > I was offering a solution. > > > > The problem being when summing a series if any member is #DIV/0! > > > > The result is #DIV/0!. > > > > A simple solution is to sum the series in an available adjacent column. > > the only solution is to resolve the #DIV/0! situation. Check the root > cause, fix it and then you have a correct summation. Everything else > won't be the right way. > > Marcus > > > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > > -- Disclaimer: Diese Nachricht stammt aus einem Google Account. Ihre Antwort wird in der Google Cloud Gespeichert und durch Google Algorythmen zwecks werbeanaöysen gescannt. Es ist derzeit nicht auszuschließen das ihre Nachricht auch durch einen NSA Mitarbeiter geprüft wird. Durch kommunikation mit diesen Account stimmen Sie zu das ihre Mail, ihre Kontaktdaten und die Termine die Sie mit mir vereinbaren online zu Google konditionen in der Googlecloud gespeichert wird. Sollten sie dies nicht wünschen kontaktieren sie mich bitte Umgehend um z.B. alternativen zu verhandeln.
Re: #DIV/0!
Am 12/24/2016 06:00 AM, schrieb Robert Marshall: I was offering a solution. The problem being when summing a series if any member is #DIV/0! The result is #DIV/0!. A simple solution is to sum the series in an available adjacent column. the only solution is to resolve the #DIV/0! situation. Check the root cause, fix it and then you have a correct summation. Everything else won't be the right way. Marcus - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
#DIV/0!
Hi Marcus, I was offering a solution. The problem being when summing a series if any member is #DIV/0! The result is #DIV/0!. A simple solution is to sum the series in an available adjacent column. If the amount shown in the original summation column is a number enter the number in the new column. If #DIV/0! Enter 0! sum as usual. To enhance ease and accuracy maintain relative positioning. In my Email I included the word amount in italics in your reply it became amount/./ Hope this helps.
Re: #DIV/0!
Am 12/23/2016 09:28 PM, schrieb Robert Marshall: As a Calc user with next to no programming experience, my solution for #DIV/0! is simple. In summing a series, in an available column , for amounts - enter the /amount/. For #DIV/0! - enter 0. To enhance ease and accuracy maintain relative positioning. Love Calc. I'm sorry but I don't understand your problem. What do you mean with "solution for #DIV/0!"? Do you have problems with some formulas? It would be great if you can explain it with different words. Thanks Marcus - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
#DIV/0!
As a Calc user with next to no programming experience, my solution for #DIV/0! is simple. In summing a series, in an available column , for amounts - enter the /amount/. For #DIV/0! - enter 0. To enhance ease and accuracy maintain relative positioning. Love Calc.