"substraction" and "division" function in OpenOffice Calc

mac1234mac · 03-07-2006, 02:46 PM

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

J_K9 · 03-07-2006, 03:24 PM

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

mac1234mac · 03-08-2006, 02:40 AM

But what if I want to divide or substract 20 cells in a column and
put the result in a cell at the bottom?.

J_K9 · 03-08-2006, 02:56 AM

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*...

mac1234mac · 03-08-2006, 03:03 AM

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.

mac1234mac · 03-08-2006, 03:28 AM

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).

golad · 12-03-2009, 05:45 AM

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.

pixellany · 12-03-2009, 07:36 AM

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.