Formulas can contain conditional statements with the basic syntax 'if A is true, then B'. Such statements are enclosed in square brackets. See
Using Conditional Statements in Formulas).
The
formula test requires that all brackets are closed. If not, an error message is returned:
The error message also reveals the position in the formula at which the operator in question is located. If there are multiple erroneous operators in the formula, the error message points only to the first one.
Clicking OK, the cursor shifts to the place in the formula where the error occurred.
Solution:
1. Delete the conditional operator if it is redundant.
2. If the operator is placed correctly, enclose it in sqaure brackets (see
Using Conditional Statements in Formulas).
Examples:
|
Correct |
Incorrect |
| Redundant operator:
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#
|
[#KOLICINA# > 20:#MpCena#*0.9] > #MpCena#
|
| Missing brackets:
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#
|
#KOLICINA# > 20:#MpCena#*0.9 #MpCena#
|