View the Most Wanted LQ Wiki articles.
 Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 LinuxQuestions.org help please... a DIFFERENCE function in Gnumeric ?!?
 Linux - Software This forum is for Software issues. Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

 03-15-2010, 11:25 PM #1 stu7 Member   Registered: Jun 2007 Posts: 90 Rep: help please... a DIFFERENCE function in Gnumeric ?!? In gnumeric I am able to write: 2 + 4 _or_ 4 - 2 _or_ 2 * 4 _or_ 4 / 2... and, happily, three of these simple math operations do have corresponding [word function] equivalents... so... we can also write, in gnumeric: SUM / PRODUCT / QUOTIENT... but, either I am going blind, or, there is simply no DIFFERENCE function therein ? Any gnumeric users know how to construct a "difference" operation ? Logically, this /should be/ something like: =DIFFERENCE(A1,A2) ...should be... but, for me, no such function available. suggestions ? thanks
 03-15-2010, 11:36 PM #2 evo2 Guru   Registered: Jan 2009 Location: Japan Distribution: Mostly Debian and Scientific Linux Posts: 5,706 Rep: Maybe not really what you are looking for, is there any reason you can't use: Code: `=sum(a1,-a2)` or Code: `=-sum(-a1,a2,a3,...)` Evo2.
03-17-2010, 01:06 PM   #3
stu7
Member

Registered: Jun 2007
Posts: 90

Original Poster
Rep:
well I had in fact looked for an INV or inverse...
if -sum(... would work, that would be ok,
Im just wondering why no DIFFERENCE function
explicitly ?

thanks for your suggestion / I will try it

Quote:
 Originally Posted by evo2 Maybe not really what you are looking for, is there any reason you can't use: Code: `=sum(a1,-a2)` or Code: `=-sum(-a1,a2,a3,...)` Evo2.

 03-17-2010, 01:21 PM #4 paulsm4 Guru   Registered: Mar 2004 Distribution: SusE 8.2 Posts: 5,863 Blog Entries: 1 Rep: Excel doesn't have a "difference" (or "sub()") function either. For the same reason - it's redundant, and unnecessary. To be redundant http://office.microsoft.com/en-us/ex...ry%20functions http://www.fifi.org/doc/gnumeric-doc...html#REFERENCE

 Tags difference, function, missing