Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
 Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 LinuxQuestions.org help please... a DIFFERENCE function in Gnumeric ?!?
 User Name Remember Me? Password
 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: 95 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 LQ Guru   Registered: Jan 2009 Location: Japan Distribution: Mostly Debian and Scientific Linux Posts: 5,753 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: 95

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

 Thread Tools Search this Thread Search this Thread: Advanced Search

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post pppaaarrrkkk Linux - Software 0 03-08-2008 02:05 PM koyi Programming 4 11-19-2005 10:19 AM kevinqian Linux - Software 0 04-04-2004 03:12 AM griv Linux - Software 0 06-30-2002 12:56 PM ry Linux - Software 1 06-30-2002 12:27 PM

All times are GMT -5. The time now is 12:23 PM.

 Contact Us - Advertising Info - Rules - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
 Advertisement
 My LQ
 Write for LQ LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
 Syndicate Latest Threads   LQ News Twitter: @linuxquestions Facebook: linuxquestions Google+: linuxquestions