Using Logical Operator Without a Logical Expression
Formulas may also contain a conditional expression in the form of 'if – then'. In the formula nomenclature, such expressions are described using square brackets (see Using logical expressions in formulas).
The formula test expects each logical operator (e.g., >, <, =) to be enclosed in square brackets. If this condition is not met, the formula test returns an error:
The message also indicates where in the formula the (possibly) redundant logical operator occurs. If there are several such inputs in one formula, it puts us on the first invalid input found.
Clicking the OK button causes the program to place the cursor on the part of the formula where the error occurred. Possible solutions:
1. Delete logical operator if it is redundant.
2. If the logical operator is entered correctly, place the expression in square brackets (see Using logical expressions in formulas).
| Correct |
Incorrect |
|
To solution 1:
[#RPrice# > 20:#RPrice#*0.9] #RPrice#
|
[#AMNT# > 20:#RPrice#*0,9] > #RPrice#
|
|
To solution 2:
[#RPrice# > 20:#RPrice#*0.9] #RPrice#
|
#RPrice#*0,9 #RPrice#
|