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 10-2 Operators and Components in Standard Formulas

Type	Operator or Component	Description	Example
Arithmetical	+	Add	Add the values in rows 4 and 5. [4] + [5] A space is needed after + . Incorrect: 5+4 Correct: 5+ 4 Correct: 5+ -4
Arithmetical	-	Subtract	Subtract 3 from the values in row 4. [4]- 3. A space is needed after - . Incorrect: 5-4 Correct: 5 - 4 Correct: 5 - -4
Arithmetical	*	Multiply	Multiply the absolute values in row 4 by 150. Abs([4])* 150
Arithmetical	/	Divide	Divide the values in row 4 by the values in row 5. [4] / [5]
Arithmetical	%	Percentage	Add the values in row 4 and multiply it by 10%. row[4].Sum*10%
Arithmetical	^	Exponential	Return the sixth exponent of row 4. [4]^6
Arithmetical	Decimal	Decimal number	Multiply the values in row 4 by 5.67. [4] * 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. Sum ([4],[12])
Unary minus	-	Changes the sign of a value	Divide the values in row 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.