Question

what is operator precedence? what operator has the highest precedence in MS Excel ?

Answer 1

Operator precedence determines the way in which operators are parsed with respect to each other. Operators with higher precedence become the operands of operators with lower precedence.

Answer 2

Answer:

You need to understand these rules if you want your formulas to produce the desired results. Table shown below lists the Excel operator precedence. This table shows that exponentiation has the highest precedence (it's performed first) and logical comparisons have the lowest precedence (they are performed last).