Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 12 Apr 2019 20:44:22 +0200formula not calculating correctlyhttps://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/Not multiplying correctly.
Cells:
- B6 $750
- E6 $0.10 (which is populated from sheet 1)
- G6 $71.25, Which should equal `B6*E6` but `750*0.10=75`
Help!Thu, 11 Apr 2019 20:59:27 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/Comment by erAck for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190178#post-id-190178Hint: when typing formulas here enclose them in backticks (you also get with Ctrl+K) otherwise the `*` asterisk multiplication operator here is a formatting operator for italics and gave B6*E6 but 750*0.10=75 in your example. I corrected that in your question (and also gave the cells as bullet list).Fri, 12 Apr 2019 15:56:10 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190178#post-id-190178Comment by ve3oat for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190092#post-id-190092But there is something wrong with what you are trying to do. It seems you are multiplying dollars times dollars, which has no meaning, and will probably give an indeterminate result. Consider this : 6 apples times 2 is meaningful, but 6 apples times 2 apples is meaningless. Perhaps column E is actually a ratio of two numbers (perhaps a rate of interest?) in which case you should multiply B6 by 0.10 (not $0.10). Possible?Thu, 11 Apr 2019 22:00:14 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190092#post-id-190092Comment by Martin691 for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190098#post-id-190098I have tried this in Calc, and it works fine even multiplying a currency by a currency which may not make sense, but it works.
I'd probably try a little more debugging, as if you try it in a blank document, it'll probably work.
Attaching the document may help us, but you may need to strip out sensitive data.Thu, 11 Apr 2019 22:27:54 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190098#post-id-190098Comment by SM_Riga for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190203#post-id-190203What is the exact formula in B6 and G6 cells and what is the result in G6 when you put 1000 instead of 750 in B6 cell?Fri, 12 Apr 2019 17:41:56 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190203#post-id-190203Comment by Aurick for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190208#post-id-190208you're right VE3OAT "0.10" is a weight not a dollar amount. I'm sorry, that's my bad. i'm sure that has to do with the difference.Fri, 12 Apr 2019 18:08:53 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190208#post-id-190208Comment by ve3oat for <p>Not multiplying correctly.
Cells:</p>
<ul>
<li>B6 $750</li>
<li>E6 $0.10 (which is populated from sheet 1)</li>
<li>G6 $71.25, Which should equal <code>B6*E6</code> but <code>750*0.10=75</code></li>
</ul>
<p>Help!</p>
https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190222#post-id-190222Hello @Aurick That's OK. If you make sure that numbers in column E are entered as pure numbers (unitless or dimensionless) and that they are all formatted as pure numbers, the formula should work alright. Formatting can sometimes have strange effects on the way numbers are treated in formulas.Fri, 12 Apr 2019 20:44:22 +0200https://ask.libreoffice.org/en/question/190082/formula-not-calculating-correctly/?comment=190222#post-id-190222