On 26/09/11 23:25, Andreas Säger wrote: > 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. > I agree if spread sheet formatting is used. The proportion or ratio is 0.8617968, the percentage is 86.17968. If you were calculating the percentage using a pencil and paper you would use 556.85 /646.15*100. If I want to perform another calculation in another cell, such as the percentage calculated above-5%, I have to be careful. If A1 = 646.15 A2 = 556.85 A4 = A2/A1 format as % A5 = A4-5 is wrong. (very simple example)
Sometimes it can just be simpler to calculate the percentage and work in % for subsequent operations than to calculate and format as %. -- 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
