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). Separate condition and value with a column:

[condition:value] - if condition is true, the value is returned.

(for detailed treatment seej Using Conditional Statements in Formulas).

The formula test requires correct syntax. Otherwise, an error message is returned:

The error message also reveals the position in the formula at which the error occured. If there are multiple syntax errors in the formula, the error message points only to the first one.

Solution:

1. Remove square brackets if they do not contain a conditional statement. Perhaps it would be wise to use round brackets.

2. If the square brackets are used correctly, make sure the condition and the value are separated by a colon.

Examples:

Correct	Incorrect
Remove square brackets: (#KOLICINA# + 100) / #MpCena#	[#KOLICINA# + 100] / #MpCena#
Use colon to separate condition and value: [#KOLICINA#>20:#MpCena#*0.9] #MpCena#	[#KOLICINA#>20=#MpCena#*0.9] #MpCena#
Use colon to separate condition and value: [#KOLICINA#>20:#MpCena#*0.9] #MpCena#	[#KOLICINA#>20|#MpCena#*0.9] #MpCena#

 

 

---