Syntax errors

Syntax errors are reported when you either check or attempt to exit the formula you are writing. You receive a message specifying the error, and the line containing the error is highlighted. You must determine and then correct the error before proceeding. Common syntax errors include the following:

  • Incorrectly spelled @function name or reserved word
  • Missing or excessive parentheses
  • Missing quotation mark on a string constant
  • No semicolon between statements

You should write a formula a little at a time and check it often as you go along. Formula syntax tends to be complex, due to nesting.