Using operators
You can use arithmetic and logical operators in table formulas. Logical operators compare two or more numeric or text values and return a result of 1 if the statement is true or 0 if the statement is false. WordPerfect includes more than 90 preset functions for mathematical, engineering, or scientific calculations. For information about each function, see “Working with tables.”
Arithmetic operators
|  |
Use the following arithmetic operators to create formulas in tables and floating cells.
|
Operator
|
What it does
|
|
+ (Addition)
|
Adds values
|
|
- (Negation)
|
Makes values negative
|
|
- (Subtraction)
|
Subtracts the value on the right from the value on the left
|
|
* (Multiplication)
|
Multiplies values
|
|
/ (Division)
|
Divides the value on the left by the value on the right
|
|
= (Total)
|
Returns a total of the sums from the + operator
|
|
% (Remainder)
|
Returns the remainder of the value on the left divided by the value on the right
|
|
% (Percent)
|
Divides the value on the left of the operator by 100. Make sure that there is another operator or a separator following the Percent operator, or that the Percent operator is the last operator in the formula. If a percent sign (%) is between two values, it becomes the Remainder operator.
|
|
^ (Power)
|
Raises the value on the left to the power indicated by the value on the right
|
|
! (Factorial)
|
Calculates the factorial of the number preceding it. Do not place an equal sign (=) following the Factorial operator; otherwise, it becomes the Not equal to operator sign.
|
Logical operators
| |
You can use the following logical operators for calculations in tables or floating cells.
|
Operator
|
What it means or does
|
|
0
|
Equal to
|
|
>
|
Greater than
|
|
<
|
Less than
|
|
< > or !=
|
Not equal to
|
|
>=
|
Greater than or equal to
|
|
<=
|
Less than or equal to
|
|
& (AND)
|
When placed between two or more logical statements, returns a 1 if all the statements are true and a 0 if any of the statements are false.
|
|
! (NOT)
|
Inverts the meaning of a function or another operator
|
|
| (OR)
|
When placed between two or more logical statements, the pipe character ( | ) returns a 1 if at least one of the statements is true and a 0 if all the statements are false.
|
|
^^ (XOR)
|
When placed between two or more logical statements, the EXclusive OR operator (XOR) returns a 1 if one or the other but not both of the statements in the formula are true (or if an odd number of statements are true). It returns a 0 if neither or both of the statements are true (or if an even number of the statements are true).
|
Using operators