Support LQ: Use code LQ3 and save \$3 on Domain Registration
 Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 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.

Notices

 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: Arch/XFCE
Posts: 17,802

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.