Re: #DIV/0!

2016-12-28 Thread Peter Kovacs
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

Re: #DIV/0!

2016-12-27 Thread Marcus
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

#DIV/0!

2016-12-23 Thread Robert Marshall
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

Re: #DIV/0!

2016-12-23 Thread Marcus
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

#DIV/0!

2016-12-23 Thread 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.