LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices

Reply
 
Search this Thread
Old 10-14-2006, 02:15 AM   #1
Toonses82
Member
 
Registered: Sep 2004
Location: Olympia, WA, USA
Distribution: Linux Mint 16 Cinnamon
Posts: 117

Rep: Reputation: 15
OOo Calc


I have a simple problem that I can't seem to figure out. I'm using an Open Office Calc Spreadsheet for my budget and I need to make a particular cell show the difference of two other cells (Cell 1 minus Cell 2). I've been able to figure out how to get the sum of certain cells and the product (multiplication) of certain cells, but not the difference. Is there a way to do this?
 
Old 10-14-2006, 02:27 AM   #2
Toonses82
Member
 
Registered: Sep 2004
Location: Olympia, WA, USA
Distribution: Linux Mint 16 Cinnamon
Posts: 117

Original Poster
Rep: Reputation: 15
Ok, so of course the minute I ask a question on the forum, I then find the answer on my own. Oh well. Thanks for reading at least and hopefully this post can serve as a useful resource for someone else.

If you want a cell to show the difference between L17 and L16 as mentioned in the previous post, in the cell, enter the equation "=L17-L16" (without the quotes) and that's it. Seems pretty self explanatory, but I had a hard time finding it for myself. This website proved useful:
http://www.tutorialsforopenoffice.or...User_Calc.html
 
  


Reply


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gnumeric or Calc? Thetargos Linux - Software 9 07-02-2006 04:10 PM
LXer: OOo Off the Wall: The Elephant in the Living Room -- OOo and MS Office LXer Syndicated Linux News 0 02-06-2006 12:01 PM
Openoffice calc dajomu Linux - Software 1 10-27-2005 05:56 PM
OOO Calc Paste shifts cells LasseW Linux - Software 0 02-03-2005 11:25 AM
openoffice calc question... marsques Linux - Software 2 07-10-2004 04:30 PM


All times are GMT -5. The time now is 05:10 AM.

Main Menu
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.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration