Excel TutorialLesson 19Free preview

Excel Parentheses

This lesson is part of Excel · All levels

Summary

The parentheses set the order of the calculations in the formula, just like basic mathematics. The contents of the curve are calculated first, and then the result is used for the next operation, so that =(2+3)*4 is worth 20 instead of 14. The curves can also be constrained, and Excel will warn if the number of opening parentheses and closing is out of balance.

Key points

The contents of the container are calculated before the other operation
The curve makes the formula easy to read and keep the order
The nesting may be several levels
The unbalanced curve triggers a syntax error

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.