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
: 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
Am 26.09.2011 14:58, Tom Davies wrote:
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
=
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
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 saege...@t-online.de wrote:
From: Andreas Säger saege...@t-online.de
Subject: [libreoffice-users] Re: percentage to get number in Calc
On 09/25/2011 07:46 PM, James wrote:
I have a number $646.15
and a number $556.85
How do I make a formula in a new cell that is the percentage of the
first number that equals the second number?
Does:
A1 = 646.15
A2 = 556.85
A3 = =A2/A1 Format|Cells|Numbers|Percent
(86.18%)
not work for