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

WordPerfect Office btnbacktotopproc Using 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

WordPerfect Office btnbacktotopproc Using 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