# How can I divide one cell contents by another?

I've always used the formula =prod(c1/d4) to divide cell C1 by D4 to get the answer. It is throwing an error #NAME?

Why?

First time here? Check out the FAQ!

How can I divide one cell contents by another?

I've always used the formula =prod(c1/d4) to divide cell C1 by D4 to get the answer. It is throwing an error #NAME?

Why?

add a comment

1

Hello @bdun,

"prod" is not a built-in function in Calc.

In order to divide cell C1 by D4 you could write `=C1/D4`

.

For integer division you could write `=QUOTIENT(C1;D4)`

.

1

(Not an answer? Not completely irrelevant, however.)

I often wondered for what reason I find `=SUM(A1;A2)`

instead of simple `=A1+A2`

in users' posts. My theory:

-1- It is partly a side-effect of the silly clickeritis we find everywhere. Some users think they **have to** click the Sigma icon if they want to get something summed up. Some "teachers" may "teach" it this way. And surely youtube will.

-2- Some users will sometimes use the `SUM`

variant consciously because they also want a result if A1 or A2 return text to the formula. I myself used something like `=SUM(A1)+MATCH(...)`

under a heading sometimes for filling down to create a sequence avoiding the need for a different cell content for the first element.

It is also not the first time that I find (garbled in this case) `=PRODUCT(A1;A2)`

instead of simple `=A1*A2`

. What about my theory now? As a German I would say, it is a screwed-up analogy to the `SUM`

case like "des Nachts" is one in German language. And: Part -2- of my mentioned theory applies respectively. `PRODUCT`

allows for text among the listed elements and correctly uses the neutral factor 1 for it (not 0 as Excel would be expected to do) !

And there were cases of `=SUM(A1-A2)`

despite the fact that this will pass the `#VALUE!`

error `A1-A2`

returns if one of the operands is text. To date I never found the (garbled again) `=PRODUCT(A1/A2). You live and learn.

1

Ehem. PROD is not a Calc function name (at least in English locale). And your formula must be `=C1/D4`

.

Asked: ** 2017-08-17 06:34:39 +0200 **

Seen: **13,065 times**

Last updated: **Aug 17 '17**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.