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:
It states whether the opening or closing bracket is missing.
Solution:
1. Remove unnecessary brackets.
2. Supply the missing brackets.
Examples:
|
Correct |
Incorrect |
| Remove unnecessary brackets:
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#
|
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#] |
| Enter missing brackets:
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#
|
[#KOLICINA# > 20:#MpCena#*0.9] #MpCena# |