order of operator precedence

The order of operations for Excel is as follows:

􀁑 Evaluate items in parentheses.

􀁑 Evaluate ranges (:).

􀁑 Evaluate intersections (spaces).

􀁑 Evaluate unions (,).

􀁑 Perform negation ([-]).

􀁑 Convert percentages (%).

􀁑 Perform exponentiation (^).

􀁑 Perform multiplication (*) and division (/), which are of equal precedence.

􀁑 Perform addition (+) and subtraction (-), which are of equal precedence.

􀁑 Evaluate text operators (&).

􀀃 Perform comparisons (=, <>, <=, >=).

Operations that are equal in precedence are performed left to right.