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 Personal Taxprep are briefly described below:
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 |
The logical operators allow you to specify a compound condition containing several comparisons.
Operator |
Example |
---|---|
AND |
[IF ([Your allowable deduction]<>
0.00 AND [Line 21400 - Child care expenses
(T778)]= 0.00 AND [CCB
- Total benefits]>0.00 )THEN] With this operator, all of the comparisons must be satisfied in order for the condition to be true. |
OR |
[IF ([Additional printing options: AUTHORIZATION in separate
paragraph] ="Yes"OR [Forms to be signed (AUTHORIZATION)]="Yes" )
THEN] With this operator, at least one comparison must be satisfied in order for the condition to be true. |
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.
Operator |
Example |
---|---|
+ |
[IF ([Line 10100 - Employment income (T4, box 14)]+[Line 12100 - Interest and other investment income (INVESTMENTS] > 100000.00 ) THEN] |
- |
[IF ([Line 10100 - Employment income (T4, box 14)]- [Line 12100 - Interest and other investment income (INVESTMENTS)] > 100000.00 ) THEN] |
* |
[IF ([Box 21 - Capital gains] * [Percentage held by Taxpayer]> 1000.00) THEN] |
/ |
[IF ([Line 12600 - Rental income - Net] / [Taxpayer - Percentage of ownership] > [Net rental income (loss)]) THEN] |
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.