Re: [libreoffice-users] Calc IF problem

At 23:45 19/10/2013 +0200, Paul Steyn wrote:
> On Sat, 19 Oct 2013 15:46:56 +0100 Brian Barker wrote:
> > Remember that multiplication precedes addition 
> > and subtraction in evaluation, so many of your 
> > parenthesis pairs are unnecessary.  You may 
> > think they clarify things, but in my experience 
> > they obfuscate the meaning of a formula and mask errors.
>
> While I agree with Brian's other points, I just 
> wanted to comment that normally, I find it much 
> better to include parentheses around sums, ...

Sums?  But sums (along with differences) often do 
need parentheses, of course: it's products and quotients that often don't.

> ... explicitly stating the order, rather than 
> relying on (sometimes differing) operator precedence rules.

"Sometimes differing"?!  Is this the new mathematics?  ;^)

> This also helps to group things, and in my 
> opinion usually makes things more clear, rather than obfuscating anything.

Chacun à son goût, of course.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@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