Ask Your Question
1

how to calculate percentage with 2 decimal value and percentage sign? [closed]

asked 2014-08-11 19:11:39 +0100

GOLAM007 gravatar image

updated 2016-03-03 17:22:23 +0100

Alex Kemp gravatar image

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%

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 17:22:35.544977

2 Answers

Sort by » oldest newest most voted
3

answered 2014-08-11 20:12:48 +0100

erAck gravatar image

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.

edit flag offensive delete link more

Comments

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

GOLAM007 gravatar imageGOLAM007 ( 2014-08-13 17:43:41 +0100 )edit

@GOLAM007 if this answer has solved your prob then plz accept it.

sangharsh gravatar imagesangharsh ( 2015-10-21 09:28:03 +0100 )edit
3

answered 2014-08-12 00:12:19 +0100

Lupp gravatar image

updated 2014-09-09 12:39:44 +0100

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.

edit flag offensive delete link more

Comments

Thank You Lupp for helping me in this regard...

GOLAM007 gravatar imageGOLAM007 ( 2014-08-13 17:45:44 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-08-11 19:11:39 +0100

Seen: 17,531 times

Last updated: Sep 09 '14