Brother International WP230B Owners Manual - English - Page 211

1. Functions Using a Single Argument @INT Gives the integer part of the argument. The decimal point and subsequent decimal digits are removed without being rounded off; an integer will remain untouched. @INT(5) gives 5 @INT(0.9) gives 0 @INT(1.1) gives 1 @SQUARE Gives the square of the argument. The argument multiplied by itself is returned; the result is always a positive number. @SQUARE(5) gives 25 @SQUARE(-5) gives 25 @SQUARE(0) gives 0 @SORT Gives the square root of the argument. The result multiplied by itself is equal to the argument. The argument may not be negative. @SQRT(25) gives 5 @SQRT(2) gives 1.41421 @SQRT(-25) is invalid @ROUND Rounds off the argument to the number of specified decimal places. Two data entries are required between the parentheses: the argument itself, and a direct number that specifies the number of decimal places. If that number is not an integer, it is first rounded off to the closest integer. OROUND(1.66666,2) gives 1.67 ROUND(1.66666,3) gives 1.667 @ROUND(1.66666,2.1) gives 1.67 @ROUND(1.66666,2.5) gives 1.667 Spreadsheet 199