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: ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

You should use Excel’s auto-complete feature to avoid such typos. You also need to factor in parentheses, as they will dictate the order of operations in your formulas.