Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 22 Sep 2020 15:08:46 +0200Help with LibreOffice Calc Equationhttps://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/ I want to put this equation into LibreCalc:
= total spend ÷ total sales x 100
I created the formula of =SUM(A16/D16)*100
But I get 7957.xxx insteqd of the 79.57 that I'm expecting. What am I doing wrong in the formula I created?Wed, 18 Jan 2017 21:31:54 +0100https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/Answer by karolus for <p>I want to put this equation into LibreCalc:</p>
<p>= total spend ÷ total sales x 100</p>
<p>I created the formula of =SUM(A16/D16)*100</p>
<p>But I get 7957.xxx insteqd of the 79.57 that I'm expecting. What am I doing wrong in the formula I created?</p>
https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?answer=85677#post-id-85677there's nothing to **`SUM`** … avoid this useless stuff
=A16/D16*100Thu, 19 Jan 2017 00:27:20 +0100https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?answer=85677#post-id-85677Comment by newbie-02 for <p>there's nothing to <strong><code>SUM</code></strong> … avoid this useless stuff</p>
<pre><code>=A16/D16*100
</code></pre>
https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=267328#post-id-267328for me `=A16/D16*100`, `=(A16/D16)*100` and `=SUM(A16/D16)*100` all produce the same result, thus i doubt the 'SUM' was the error here, more likely cell formatting or 'late apply of format change' (not evaluated until first edit or 'touch' of value) stepped in ...Tue, 22 Sep 2020 15:08:46 +0200https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=267328#post-id-267328Comment by jridgers for <p>there's nothing to <strong><code>SUM</code></strong> … avoid this useless stuff</p>
<pre><code>=A16/D16*100
</code></pre>
https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=85692#post-id-85692Thanks. I was over thinking it.Thu, 19 Jan 2017 06:07:49 +0100https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=85692#post-id-85692Answer by Mike Kaganski for <p>I want to put this equation into LibreCalc:</p>
<p>= total spend ÷ total sales x 100</p>
<p>I created the formula of =SUM(A16/D16)*100</p>
<p>But I get 7957.xxx insteqd of the 79.57 that I'm expecting. What am I doing wrong in the formula I created?</p>
https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?answer=85664#post-id-85664Possibly you used Percent as cell format? If so, then you didn't need that 100.
Btw, the proper name is LibreOffice Calc.Wed, 18 Jan 2017 21:35:26 +0100https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?answer=85664#post-id-85664Comment by jridgers for <p>Possibly you used Percent as cell format? If so, then you didn't need that 100.</p>
<p>Btw, the proper name is LibreOffice Calc.</p>
https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=85693#post-id-85693Thanks, noted.Thu, 19 Jan 2017 06:08:08 +0100https://ask.libreoffice.org/en/question/85663/help-with-libreoffice-calc-equation/?comment=85693#post-id-85693