Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 21 Oct 2015 09:28:03 +0200how to calculate percentage with 2 decimal value and percentage sign?https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer.
My Operating System is ubuntu 12.04 LTS.
LibreOffice Calc 3.5.7.2
my work details
in Cell F2 Total Marks Obtained 460 Out of 700
then calculate percentage in cell G2
Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571
then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%
Mon, 11 Aug 2014 19:11:39 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/Answer by erAck for <p>when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer.
My Operating System is ubuntu 12.04 LTS.
LibreOffice Calc 3.5.7.2
my work details
in Cell F2 Total Marks Obtained 460 Out of 700
then calculate percentage in cell G2
Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571
then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%</p>
https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?answer=38167#post-id-38167**Either** calculate `=(F2/700)*100` and do **not** apply the percentage format because the result you got is already expressed as percentage, **or** calculate `=F2/700` **and** apply a percentage format that internally multiplies with 100 to display the correct percentage.Mon, 11 Aug 2014 20:12:48 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?answer=38167#post-id-38167Comment by sangharsh for <p><strong>Either</strong> calculate <code>=(F2/700)*100</code> and do <strong>not</strong> apply the percentage format because the result you got is already expressed as percentage, <strong>or</strong> calculate <code>=F2/700</code> <strong>and</strong> apply a percentage format that internally multiplies with 100 to display the correct percentage.</p>
https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=59793#post-id-59793@GOLAM007 if this answer has solved your prob then plz accept it.Wed, 21 Oct 2015 09:28:03 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=59793#post-id-59793Comment by GOLAM007 for <p><strong>Either</strong> calculate <code>=(F2/700)*100</code> and do <strong>not</strong> apply the percentage format because the result you got is already expressed as percentage, <strong>or</strong> calculate <code>=F2/700</code> <strong>and</strong> apply a percentage format that internally multiplies with 100 to display the correct percentage.</p>
https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=38273#post-id-38273Thank You erAck for helping me in this regard. Its work superb` Second Method is actually work that i want. Here i am using second method. Many Many Thanks...Wed, 13 Aug 2014 17:43:41 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=38273#post-id-38273Answer by Lupp for <p>when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer.
My Operating System is ubuntu 12.04 LTS.
LibreOffice Calc 3.5.7.2
my work details
in Cell F2 Total Marks Obtained 460 Out of 700
then calculate percentage in cell G2
Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571
then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%</p>
https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?answer=38174#post-id-38174Please note: In Calc the % character can be used as a POSTFIX OPERATOR for any term that may occur as a factor. It denotes dividing by 100. Therefore you MUST NOT use it as a fomal apposition. It actually causes a calculation.
A general remark:
From the mathematical point of view a percentage is simply a ratio. "InterestRate = Interest/Capital", e.g. The concept of the "InterestRate" does not depend on the form we prefer to mould the result in. You may contract an interest rate of "7/128" e.g. which is the same as "0.0546875" or "5.46875%" or "1/128 less than 1/16". There were times when people preferred to put it this way. Nowadays we are trained to prefer expressing ratios (rates) with the denominator 100. Many are trained to believe that "percents" are something of a specific value. They aren't. We are talking about a preferred way of communication.
**Using spreadsheets you should always strictly distinguish between VALUES and the FORMATS they are displayed in. Concerning ratios this includes distinguishing between the ratio itself and the numerator of a fraction representing it based on a denominator of 100. Calling both of these numbers "percentage" is wrong by a factor of 100.**
Thus: **Calculate the RATIO (or the RATE), not a percentage! Calc will help you displaying it in the "percentage format". And you may safely forget all the formulae containing a factor or a divisor of 100.**
Tue, 12 Aug 2014 00:12:19 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?answer=38174#post-id-38174Comment by GOLAM007 for <p>Please note: In Calc the % character can be used as a POSTFIX OPERATOR for any term that may occur as a factor. It denotes dividing by 100. Therefore you MUST NOT use it as a fomal apposition. It actually causes a calculation.</p>
<p>A general remark:</p>
<p>From the mathematical point of view a percentage is simply a ratio. "InterestRate = Interest/Capital", e.g. The concept of the "InterestRate" does not depend on the form we prefer to mould the result in. You may contract an interest rate of "7/128" e.g. which is the same as "0.0546875" or "5.46875%" or "1/128 less than 1/16". There were times when people preferred to put it this way. Nowadays we are trained to prefer expressing ratios (rates) with the denominator 100. Many are trained to believe that "percents" are something of a specific value. They aren't. We are talking about a preferred way of communication.</p>
<p><strong>Using spreadsheets you should always strictly distinguish between VALUES and the FORMATS they are displayed in. Concerning ratios this includes distinguishing between the ratio itself and the numerator of a fraction representing it based on a denominator of 100. Calling both of these numbers "percentage" is wrong by a factor of 100.</strong> </p>
<p>Thus: <strong>Calculate the RATIO (or the RATE), not a percentage! Calc will help you displaying it in the "percentage format". And you may safely forget all the formulae containing a factor or a divisor of 100.</strong></p>
https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=38275#post-id-38275Thank You Lupp for helping me in this regard...Wed, 13 Aug 2014 17:45:44 +0200https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/?comment=38275#post-id-38275