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.