Brother International WP230B Owners Manual - English - Page 203

Direct Numbers Direct numbers are digits, and possibly a decimal point. Other characters make the data invalid. The maximum number of digits is 13 (zeroes preceding other digits are not counted). Here are some examples of valid and invalid direct numbers: 1234 Valid 0.94956 00001 000000000000001 (zeroes are discarded) Invalid 1,000 (comma is invalid) 125$ ($ is invalid) 12a12 (a is invalid) 99999999999999 (more than 13 digits) Formulas A formula is made up of operators, operands, and possibly pairs of parentheses to change the order of calculation. Operators The operators recognized by the word processor are, in order of precedence: Symbol + - Operator Positive and negative sign # Exponentiation * / Multiplication, division +- Addition, subtraction • The + and - operators are considered as the sign of the following operand when they come first in a formula, or immediately after a left parenthesis or another operator. • The # operator performs only integer exponentiation. If the exponent (the next operand after #) has a decimal value, it is rounded off to the closest integer before exponentiation is performed. Therefore, you cannot use this operator to calculate roots (although roots can always be written as a decimal exponent in math). Zero with any positive exponent gives zero. Zero with a negative exponent gives "Invalid entry." • Division by zero is invalid. • A sequence of three or more operators makes a formula invalid (2+*-1 is invalid). Spreadsheet 191