Unbalanced conditions [], missing ]!
Formulas may also contain a conditional expression of the form 'if-then' In formula nomenclature, such expressions are described using square brackets (see Using Logical Expressions in Formulas).
The formula test expects each square bracket to have its own pair in the bracket. If this condition is not met, the formula test returns an error:
At the end of the message, you can also see whether a parenthesis or a bracket is missing. There are two solutions:
1. Delete the square bracket/bracket if it is redundant.
2. If the square bracket/bracket is entered correctly, assign it the correct pair at the end/beginning of the logical expression.
| Correct |
Incorrect |
| To solution 1:
[#MpPrice# > 20:#MpPrice#*0.9] #MpPrice#
|
[#MpPrice# > 20:#MpPrice#*0.9] #MpPrice#] |
| To solution 2:
[#MpPrice# > 20:#MpPrice#*0.9] #MpPrice#
|
#MpPrice# > 20:#MpPrice#*0,9] #MpPrice# |