Brother WP330MDS - Manual (Page 200)

Formulas
A formula is made of operators, operands, and possibly pairs of parentheses to
change the order of calculation.
Operators
The operators that are recognized by the word processor are, in order of
precedence:
Symbol Operator
+ - Positive and negative sign
# Exponentiation
Multiplication, division
+ - Addition, subtraction
• The + and operators are considered as the sign of the following operand when
they come first in a formula, immediately after a left parenthesis or another
operator.
• The # operator performs only integer exponentiation. If the exponent (the next
operand after #) has a decimal value, it will be rounded to the closest integer
before exponentiation is performed. Therefore, this operator cannot be used to
calculate roots (although roots can always be written as a decimal exponent in
math). Zero with any positive exponent gives zero. Zero with a negative
exponent gives “Invalid entry.”
• Division by zero is invalid.
• A sequence of three or more operators makes a formula invalid (2+*-1 is
invalid),
• A sequence of two operators is valid only if the second operator is a sign + or -
(5*-2 is valid and gives -10 while 1-*2 is invalid).
Operands
An operand can be a valid number, the address of a cell containing numeric data, a
function, or a valid formula included in a pair of parentheses.
Examples of valid operands
123 direct number
A1 oral cell address; A1 must contain numeric data
@SUM(A1..B6) valid function
(A1+5*@SUM(B1..B12)) valid formula included in a pair of parentheses
190