subtracting value in Gnumeric

[John Moniz]

Chris Aitken wrote:

>Chris Aitken wrote:
>
>  
>
>>Does anyone know the formula to subtract the values of one
>>cell from another in Gnumeric?
>>
>>I know how to add a contiguous group of cells:
>>
>>=sum(B2:B30)
>># then I hit the arrow button to activate the formula.
>>    
>>
>
>I actually figured it out myself. Just substitute the : with
>-
>
>  
>
>>What is it to subtract one cell value from another. To subtract
>>the value at B10 from B3, should I expect something like..?
>>
>>=difference(B10-B3)
>>    
>>
>
>=sum(B3-B10)
>
>That did it. I'm a grade 10 math flunky so I
>didn't think my inbtuition would count, but it did.
>Subtracting is just adding, where one number is
>negative.
>
>Or should I just take my working formaula and
>quit while I'm ahead?
>
>Chris
>  
>
To subtract B10 from B3, it's simply "=B3-B10" (no quotes). You don't 
need the "difference" in there.


--
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