subtracting value in Gnumeric

[Taavi Burns]

On Mon, Nov 24, 2003 at 12:47:31PM -0500, Kevin Cozens wrote:
> >=sum(B3-B10)
> >
> >That did it.
> 
> Glad you found another way to subtract two values. As someone else indicated,
> you don't need to invoke a formula or procedure (ie. 'sum') to do simple
> math. FYI, 'sum' allows you to add up a range of cells in a column or row by
> specifying only the first and last cell in the range. It 

Indeed, =sum(B3-B10) probably subtracts B10 from B3, and then "sums" the whole
1 element in the list (i.e. the value of B3-B10).

> is just a short cut to avoid having to say something like
> =B3+B4+B5+B6+...+B9+B10.

Not only that, but if you insert rows properly, the sum() is likely to include
the new inserted rows, where specifying cells explicitly won't.


-- 
taa
/*eof*/
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml