Operators
When combined with cells and comparison values, operators allow calculations to determine if conditions are true or false. There are comparison, logical and mathematical operators.
The operators available in Taxprep for Trusts are briefly described below:
Comparison operators
Comparison operators allow you to compare cells or to compare cells with a specified value.
|
Operator |
Description |
|---|---|
|
< |
Less than |
|
<= |
Less than or equal to |
|
> |
Greater than |
|
>= |
Greater than or equal to |
|
= |
Equal to |
|
< > |
Not equal to |
Logical operators
The logical operators allow you to specify a compound condition containing several comparisons.
|
Operator |
Example |
|---|---|
|
AND |
[IF([ID.B218]="Yes" And [Balance due]> 1.99) THEN] With this operator, all of the comparisons must be satisfied in order for the condition to be true. |
|
OR |
[ELSE IF ([ID.B218] = "Yes" And ([Refund or balance due] < 2.00 Or [Balance due] < 2.00)) THEN] With this operator, at least one comparison must be satisfied in order for the condition to be true. |
Mathematical operators
Mathematical operators allow you to perform a calculation within a condition using the value of several cells or by combining the value of a cell and a specified value.
How to add an operator
To add an operator, proceed as follows:
- From the Letter Editor, place your cursor where you want to add the operator.
The cursor must be within a conditional instruction in order to insert an operator (for example, [IF () THEN]) and after a comparison value or a condition. - On the Insert menu, click Operator, then click the operator that you want to add.