Ask Your Question
0

How can I divide one cell contents by another?

asked 2017-08-17 06:34:39 +0200

bdun gravatar image

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?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2017-08-17 06:56:58 +0200

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

edit flag offensive delete link more

Comments

Odd, because in the Windows version of LO Calc it is. I'm currently using the Linux version. Thank you.

bdun gravatar imagebdun ( 2017-08-17 08:51:32 +0200 )edit

I'm using Windows version.

Mike Kaganski gravatar imageMike Kaganski ( 2017-08-17 10:46:49 +0200 )edit
0

answered 2017-08-17 06:58:28 +0200

librebel gravatar image

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

edit flag offensive delete link more

Comments

Odd, because in the Windows version of LO Calc it is. I'm currently using the Linux version. Thank you.

bdun gravatar imagebdun ( 2017-08-17 08:51:12 +0200 )edit
0

answered 2017-08-17 10:22:35 +0200

Lupp gravatar image

updated 2017-08-17 10:31:45 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 7,178 times

Last updated: Aug 17 '17