Mathematical Operators in Expressions
Operators are symbols that perform arithmetical tasks or comparisons, or refer to ranges of columns, rows, or cells. Use operators in formulas that perform calculations on data rows or columns.
Table 11-3 Operators in Standard Formulas
Type | Operator | Description | Example |
---|---|---|---|
Arithmetical |
+ |
Add |
Add the values in rows 4 and 5.
A space is needed after + .
|
Arithmetical |
- |
Subtract |
Subtract 3 from the values in row 4.
A space is needed after - .
|
Arithmetical |
* |
Multiply |
Multiply the absolute values in row 4 by 150.
|
Arithmetical |
/ |
Divide |
Divide the values in row 4 by the values in row 5.
|
Arithmetical |
% |
Percentage |
Add the values in row 4 and multiply it by 10.
|
Arithmetical |
^ |
Exponential |
Return the sixth exponent of row 4.
|
Arithmetical |
Decimal |
Decimal number |
Multiply the values in row 4 by 5.67.
|
Reference |
[] |
Specifies a row, column, or cell in a grid. Use numbers for rows and letters for columns. |
Add the values in rows 4 and 12.
|
Unary minus |
- |
Changes the sign of a value |
Divide the values in column 4 by 12 and change the sign of the result. ([4] / 12) |
Tip:
Use the Eval
function to perform arithmetic operations as part of a function parameter. See Eval.
Tip:
Natural precedence determines the order to carry out operations in expressions with multiple operators. See Natural Precedence.