Brother WP330MDS - Manual (Page 204)

NOTES:
* Up to 6 pairs of parentheses can be nested. Using more than 6 pairs of nested
parentheses makes the formula invalid. The formula will also be invalid if paren­
theses do not come by pairs.
• Parentheses can be used for the simple purpose of making the data numeric.
(A 1-hA2) or (A1)+A2 can be used instead of +A1+A2.
Maximum Length of a Formula
The maximum length of a formula is 55 characters (the total length of the input area).
If a formula is longer, try to simplify it by using functions. It should be noted that
entering many long formulas may cause the memory to become full before all the
cells are occupied.
Math Functions
Functions are made by the @ character, followed with a valid function name in capital
or small letters (see list below), and a pair of parentheses containing the argument(s)
of the function.
Arguments are the numeric data that the function will process to return a result. Valid
arguments are numbers and/or cell addresses separated with commas, or a range
defined by the addresses of two opposite corners, separated with two periods (..).
Example 1:@SUM(1,A1,4,B6)
returns the sum 1+A1+4+B6
@SUM(A1..B4)
returns the sum A1+B1+A2+B2+A3+B3+A4+B4
Some functions like @INT accept only one argument. In that case, using more than
one argument or using a range makes the formula invalid.
A range cannot be used simultaneously with numbers or addresses.
Example 2: @SUM(1 ,A1 ..B4) and @SUM(A23,A1 ..B6) are invalid.
Although a function is a valid operand of a formula, a formula is not a valid argument
of a function.
Example 3:1+A1+@SUM(B2..C5) is a valid formula
@SUM(1+2), @SUM(+A1), and @SUM(1+A1) are all invalid
194