Re: [office-formula] Change precedence of reference union

["Tomas Mecir" <mecirt@gmail.com>]

On 7/18/06, David A. Wheeler <dwheeler@dwheeler.com> wrote:
> Excel's documentation at http://support.microsoft.com/kb/25189/EN-US/ ) claims that its precedence is (from highest to lowest) Range, Intersection, Union in that order. I've
> checked, and it's true for Excel 2003.

Aye, agreed. Makes sense from maths viewpoint, given as intersection
is logical AND, union is logical OR, with AND having higher priority
than OR (AND is basically multiplication, OR is addition). And Excel
compatibility is a nice bonus :)

/ Tomas