Hi :) 3^2 does =9 ? I thought all this was so obvious that it doesn't need explanation except perhaps a brief note when you select the function using the fx button.
However, i do find that people who complain about a lack of space don't realise that putting files back in the filing cabinet in the proper order means that 1. they have more space on their desk 2. that it becomes possible for people to find files without shouting. I don't think it is our job to teach people maths. I do agree that the line between teaching maths and giving hints&tips to business users is a very blurry line sometimes and the rounding tip be a good example of that. Regards from Tom :) ________________________________ From: Regina Henschel <[email protected]> To: [email protected] Sent: Fri, 10 June, 2011 23:16:08 Subject: Re: [libreoffice-documentation] Re: Collecting small things in the Wiki Hi Tom, this is not about the reason, but about where document the reasons, so that they can be found by users. Tom Davies schrieb: > Hi :) > In Calc i get -8 for > =-2^3 > and for =2^3 > it gives me 8. My default, try =-3^2 Also the > = 9.87 + 6.54 > gives me 16.41. My locale is not set to allow euros at the moment. > > I think the Euros problem is likely to be a rounding error if the 9.87 and/or > the 6.54 are the results of calculations. It is possible to bracket > calculations and use functions such as "Round" to round-off extra digits rather > than just using formatting to hide them. Often the "Round" functions tend to > drop numbers such as 9.869 to 9.860, well 9.86 so it's wise to test it and then > maybe add 0.005 before rounding-off. For example > =SUM(D6:D8)/3 > would become > =ROUND((SUM(D6:D8))+0.005) The point here is, where to put such explanations. Kind regards Regina -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/documentation/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
