Brother International WP230B Owners Manual - English - Page 208

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 with the @ character, followed by 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 the function uses 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(82..C5) is a valid formula. @SUM(1+2), @SUM(+A1), and (7, SUM(1+A1) are all invalid. What is a Range of Cells? A range is a group of cells enclosed in a rectangle and can be specified by the addresses of two opposite corners. When using math functions, you specify a range using the notation Al..C3, for example. You could also specify the same range with A3..C1, C1..A3, or C3..A1. 196 Spreadsheet