Note: Notice how Excel color-codes the formulas to the matching cells, including the opening and closing parentheses, in an effort to help you understand the syntax of each condition in the formula.

Finally, parentheses are used in Excel to nest functions. In this example, the SUM function is nested within the IFERROR function so that if the result returns an error, a blank cell is displayed: ...