Hi :) True. It's good to have options to suit different circumstances ;) Regards from Tom :)
--- On Mon, 26/9/11, Steve Edmonds <[email protected]> wrote: From: Steve Edmonds <[email protected]> Subject: Re: [libreoffice-users] Re: percentage to get number in Calc To: [email protected] Date: Monday, 26 September, 2011, 20:35 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 -- 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
