Re: [libreoffice-users] Re: percentage to get number in Calc

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 <saegerei@t-online.de> wrote:

From: Andreas Säger <saegerei@t-online.de>
Subject: [libreoffice-users] Re: percentage to get number in Calc
To: users@global.libreoffice.org
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: users+help@global.libreoffice.org
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: users+help@global.libreoffice.org
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