** Reply to message from Tom Davies <[email protected]> on Mon, 26 Sep 2011 13:58:52 +0100 (BST)
It depends on what the user wants in the cell. If he wants the actual percentage then use proper mathematical notation and write it as (556.85/646.15)*100. That way there is no ambiguity for people or the processor. If, however, since the percentage is used in calculations then leave it as 556.85/646.15 and just change the cell format to percentage. That will display the actual percentage as 86.xx, but leave the value for calculations as .86xx. Cliff > Hi :) > It's not really wrong but there needs to be some indication that it is a > percentage figure. The original numbers don't really warrant more than 2 > decimal places. Another way of removing problems with ambiguity would be to > write the equation as > = 556.85 * 100 / 646.15 > Then it doesn't matter if (100/646.15) is calculated first or the (556.85 * > 100), either way the answer is about the same, hopefully exactly the same. > Regards from > Tom :) > > > --- On Mon, 26/9/11, Andreas Säger <[email protected]> wrote: > > From: Andreas Säger <[email protected]> > Subject: [libreoffice-users] Re: percentage to get number in Calc > To: [email protected] > Date: Monday, 26 September, 2011, 11:25 > > Am 26.09.2011 05:58, Steve Edmonds wrote: > > Hi. A spreadsheet is a different way of working. At school we would have > > learned 556.85 /646.15*100 to calculate the percentage but formatting in > > the spreadsheet as a percentage saves multiplying by 100. > > steve > > > > But 86.17968 is wrong. 86.17968 does not reflect the relation between the 2 > numbers which is 0.8617968. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
