LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
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


Reply
 
Search this Thread
Old 03-07-2006, 01:46 PM   #1
mac1234mac
Member
 
Registered: Sep 2005
Posts: 183

Rep: Reputation: 30
"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
 
Old 03-07-2006, 02:24 PM   #2
J_K9
Member
 
Registered: Nov 2004
Distribution: Slackware 11, Ubuntu 6.06 LTS
Posts: 700

Rep: Reputation: 30
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
 
Old 03-08-2006, 01:40 AM   #3
mac1234mac
Member
 
Registered: Sep 2005
Posts: 183

Original Poster
Rep: Reputation: 30
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?.
 
Old 03-08-2006, 01:56 AM   #4
J_K9
Member
 
Registered: Nov 2004
Distribution: Slackware 11, Ubuntu 6.06 LTS
Posts: 700

Rep: Reputation: 30
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*...
 
Old 03-08-2006, 02:03 AM   #5
mac1234mac
Member
 
Registered: Sep 2005
Posts: 183

Original Poster
Rep: Reputation: 30
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.
 
Old 03-08-2006, 02:28 AM   #6
mac1234mac
Member
 
Registered: Sep 2005
Posts: 183

Original Poster
Rep: Reputation: 30
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).
 
Old 12-03-2009, 04:45 AM   #7
golad
LQ Newbie
 
Registered: Dec 2009
Posts: 1

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

Quote:
Originally Posted by mac1234mac View Post
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.
 
Old 12-03-2009, 06:36 AM   #8
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 730Reputation: 730Reputation: 730Reputation: 730Reputation: 730Reputation: 730Reputation: 730
Quote:
Originally Posted by golad View Post
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.
 
  


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
Telling people to use "Google," to "RTFM," or "Use the search feature" Ausar General 77 03-21-2010 11:26 AM
Replacing "function(x)" with "x" using sed/awk/smth Griffon26 Linux - General 3 11-22-2006 10:47 AM
When "function pointer" meets "template"... I can't get rid of this compiling er cyu021 Linux - Software 3 12-17-2004 07:52 PM
"Function not implemented" error in call to "sem_open()" Krishnendu8 Linux - Newbie 1 06-07-2003 02:52 AM
"Function not imlemented" error in call to "sem_open()" Krishnendu8 Linux - Networking 0 06-07-2003 02:19 AM


All times are GMT -5. The time now is 12:33 AM.

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