Re: Complex Calculations

[John Machin <sjmachin lexicon net>]

Ralph Shumaker wrote:
> John Machin wrote:
> > Ralph Shumaker wrote:
> >  
> > > John Machin wrote:
> > >    
> > > > Secondly, you don't need sum(En-Fn) ... just En-Fn is enough.
> > > >         
> > > En-Fn will give you the difference.  sum(En-Fn) is different.     
> >
> > Where x is a scalar, how can sum(x) differ from x?
> >   
>
> In gnumeric 1.6.3:
> A1 5
> B1 7
> C1 =sum(A1-B1)

Well my (Windows) Gnumeric 1.6.3 produces -2, as do (a) Excel (b) common 
sense

>   shows 12
> A2 5
> B2 7
> C2 =A1-B1
>   shows -2
>
> I used what Fred wrote.  And what you wrote appeared to me to be 
> different from what I wrote.  And gnumeric seems to bear me out.