Re: [office-formula] IMSUM

[Eike Rathke <erack@sun.com>]

Hi Patrick,

On Thursday, 2009-12-10 09:23:57 -0500, Patrick Durusau wrote:

> We say for IMSUM:
>
>> Sum (add) a set of complex numbers, including all numbers in ranges
>>
> What does "...including all numbers in ranges." mean?

Same in the summary of SUM.

Should probably had been "sequences" instead of "ranges", as the
function works on a list of ComplexSequence (IFSUM) respectively
NumberSequence (SUM) arguments.

Or better omit ", including all numbers in ranges" completely, since the
conversion to ComplexSequence respectively NumberSequence is defined.

> Hmmm, while writing this post, it occurs to me that a range of numbers  
> could be expressed by two complex numbers.
>
> Would this function add all the complex numbers between those two  
> complex numbers? If so, are the ranges inclusive or exclusive of the  
> numbers at either end of the range?

No, this is not related to a range of numbers.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature