Brother International WP1700MDS Owners Manual - English - Page 198

Example 4: ((3 *4+1) *4+3) *4-12 cn (13 *4+3) *4-12 x m 55*4-12 00) 220-12 208 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 invalidifparentheses do not come bypairs. • Parentheses can be used for the simple purpose of making the data numeric. (A1+A2) or (A1)+A2 can be usedinstead 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 (see below). 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: (4' SUM(1,A1,4,B6) returns the sum 1+A1+4+B6 @SUM(Al..84) returns the sum Al+B1+A2+B2+A3-033+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: 14414/1+ @ SUM(B2..C5) is a valid formula @SUM(1+2), @SUM(+Al), and @SUM(1+Al) are all invalid 1RR