LinuxQuestions.org "substraction" and "division" function in OpenOffice Calc
 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.

 03-07-2006, 01:46 PM #1 mac1234mac Member   Registered: Sep 2005 Posts: 183 Rep: "substraction" and "division" function in OpenOffice Calc Hello! Is it true that there is no "substraction" and "division" functions in OpenOffice Calc or in Excel?. I tried to find such functions and could not find it. There is "Multiplication" function and no "division"?. How can it be possible?. Cheers
 03-07-2006, 02:24 PM #2 J_K9 Member   Registered: Nov 2004 Distribution: Slackware 11, Ubuntu 6.06 LTS Posts: 700 Rep: Err.. put this into a cell: =sum(5-3) And this into another: =sum(20/2) I think that answers your question. It would be a bit odd if an application as advanced as OO.org Calc didn't have subtraction or division capabilities Cheers, -jk
 03-08-2006, 01:40 AM #3 mac1234mac Member   Registered: Sep 2005 Posts: 183 Original Poster Rep: question But what if I want to divide or substract 20 cells in a column and put the result in a cell at the bottom?.
 03-08-2006, 01:56 AM #4 J_K9 Member   Registered: Nov 2004 Distribution: Slackware 11, Ubuntu 6.06 LTS Posts: 700 Rep: Then you put in the cells- A1: 10000 A2: 100 A3: 50 A4: 60 A5: 20 A7: =sum(A1-A2-A3-A4-A5) The concept is quite simple. Replace the - signs with whatever you want to do, eg =sum(A1*A2*...
 03-08-2006, 02:03 AM #5 mac1234mac Member   Registered: Sep 2005 Posts: 183 Original Poster Rep: doubt But I'd like to do it automatically. As it is done with "sum" function. What if I'd have to divide or substract 100 cells. I would have to create formula by hand for all these cells. That's no good.
 03-08-2006, 02:28 AM #6 mac1234mac Member   Registered: Sep 2005 Posts: 183 Original Poster Rep: OK, it would be enough for me if I could create formula which would contain only uppermost and downmost cell (first at the top and last at the bottom).
12-03-2009, 04:45 AM   #7
LQ Newbie

Registered: Dec 2009
Posts: 1

Rep:
Did u find your solution? I ve similar problem

Quote:
 Originally Posted by mac1234mac But I'd like to do it automatically. As it is done with "sum" function. What if I'd have to divide or substract 100 cells. I would have to create formula by hand for all these cells. That's no good.
Hi Mac,
I also want to have one column, which has values of column A divide
column B, and put in column C. Do u know how?

thanks.

12-03-2009, 06:36 AM   #8
pixellany
LQ Veteran

Registered: Nov 2005
Location: Annapolis, MD
Distribution: Mint
Posts: 17,809

Rep:
Quote:
 Originally Posted by golad Hi Mac, I also want to have one column, which has values of column A divide column B, and put in column C. Do u know how? thanks.
You have posted in a thread that is over 3 years old, and is not quite the same question as yours.

If I understand correctly, you want ---For each row, the value in column C to be the value in A divided by the value in B.

Simply create the equation in the first row of C, then select the cell, click on the black square in the lower right corner, and drag through all the cells which are to have the same formula.

 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 Ausar General 77 03-21-2010 11:26 AM Griffon26 Linux - General 3 11-22-2006 10:47 AM cyu021 Linux - Software 3 12-17-2004 07:52 PM Krishnendu8 Linux - Newbie 1 06-07-2003 02:52 AM Krishnendu8 Linux - Networking 0 06-07-2003 02:19 AM

LinuxQuestions.org

All times are GMT -5. The time now is 04:21 AM.

 Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -