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

** Reply to message from Tom Davies <tomdavies04@yahoo.co.uk> 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 <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