Brother International WP230B Owners Manual - English - Page 212
A2,A3,61,B2,63
View all Brother International WP230B manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 212 highlights
2. Functions Using Multiple Arguments @AVG Gives the average value of the arguments. The sum of the arguments is calculated; then that sum is divided by the total number of arguments. @AVG(1,2,3,4) gives (1+2+3+4)/4 = 2.5 @AVG(175) gives 175/1 = 175 @COUNT Gives the number of non-blank cells. This function is an exception to the general rules in that: 1) the arguments MUST be cell addresses, and 2) the cell referred to may contain alphanumeric or numeric data. @COUNT(Al ,A2,A3,A4) gives 3 if Al contains 5 (numeric), A2 contains your name (alphanumeric), A3 contains ERROR (this is not a blank cell), and A4 is empty. @MAX Gives the greatest argument (maximum). Remember that a positive argument is always greater than a negative one. @MAX(1,234) gives 234 a, MAX(1,-99999) gives 1 @MIN Gives the smallest argument (minimum). Remember that a negative argument is always smaller than a positive one. OMIN(1,234) gives 1 @MIN(-1,99999) gives -1 @SUM Gives the sum of the arguments. This function is very useful in shortening long sums when the arguments belong to a range. @SUM(1,2,3,4,5) gives 15 @SUM(Al ,A2,A3,61,B2,63) is equivalent to @SUM(A1..B3) @TSUM Gives the total sum of a range of cells, and also the sum of each row and column of the range if they contain data. This function is an exception to the general rules in that: 1) the argument MUST be a range, and 2) results are displayed not only in the selected cell (total sum), but also in the column to the right and in the row below the range. You must therefore be sure that the column to the right and the row below the range are empty. See the next page for an example. 200 Spreadsheet