Opening or closing square bracket missing!
Opening or closing square bracket missing!
Opening or closing
square bracket missing!
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# |