Re: Range operators



Sorry,

the Gnumeric Help says that SUM-Function is Excel compatible. And Excel declares the Komma as an operator and not as a delimeter of two arguments. A Komma is a set union operator and a Blank is a intersection operator. It is not an excuse for Gnumeric when Excel makes an error. Gnumeric is better than Excel (hopefully)!

Regards
Klaus

On 21-Mar-09, at 4:30 PM, Morten Welinder wrote:

It's seen as two arguments to SUM.  If you want the comma to
be an operator, use an extra parenthesis.

I doubt this will work in Gnumeric, though.  Our union support
is next to non-existent.

Morten





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]