Error messages when writing formulae
- Last UpdatedAug 14, 2026
- 1 minute read
If there are any errors in the formulae entered an error message will be shown. Possible error messages are shown in the table below. The string %s in the example error message shown below is a placeholder for a string that shows more details about the error.
Error messages when writing formulae
|
Error Message |
Description |
Example |
Instance |
|
Unexpected symbols at end of expression: '%s'. |
Syntax error. The symbols following the given expression cannot be understood. |
X+5) |
Unexpected symbols at end of expression: ')' |
|
Missing ')' after '%s'. |
Syntax error. The expression is missing a parenthesis. |
X + (4 * 3 |
Missing ')' after 'X + (4 *’ |
|
Missing ')' or ',' after '%s'. |
Syntax error. The expression is missing a parenthesis or comma. |
IF (X > 0, X 0) |
Missing ')' or ',' after 'IF(X > 0, X' |
|
Expected an identifier after '%s'. |
Syntax error. An identifier is missing after a given expression. |
IF (X > 0, X, ) |
Expected an identifier after ')' |
|
Unknown function '%s' |
The operation or function indicated cannot be recognised by the parser. |
LN(NOT (X = X)) |
Unknown function LN (bool) |
|
Type mismatch: '%s' can't act on '%s' |
Type mismatch error. The types of the operator and operand do not match. |
NOT LOG10(X) |
Type mismatch: 'NOT' can’t act on double |
|
Type mismatch: '%s' can't act on '%s', '%s' |
Type mismatch error. The types of the operator and operands do not match. |
LOG10(X) AND LOG10(Y) |
Type mismatch: 'AND' can’t act on double, double |
|
Unidentified error in formula |
Miscellaneous error. An unknown error has occurred. |
X = X + 1 |
Unidentified error in formula |