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