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%
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.
Thank 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…
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.
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.
Thank You Lupp for helping me in this regard…