Using operators in formula expressions
You can use the following common operators in formula expressions.
Operator  Description 


If both operands are numbers, this operator adds the left and right operands. If either operand is a string, this operator concatenates the left and right operands as strings.
For example, the expression 

Subtracts the right operand from the left operand. You can only use this operator with numeric operands. 

Divides the left operand by the right operand. You can only use this operator with numeric operands. 

Multiplies the left and right operands. You can only use this operator with numeric operands. 

Raises the left operand to the power of the right operand (exponentiation). You can only use this operator with numeric operands. 

Returns the remainder from dividing the left operand by the right operand. The result has the same sign as the left operand. This behavior differs from the modulo operation. You can only use this operator with numeric operands. 

Returns 

Returns 

Returns 

Returns 

Returns 

Returns 

Returns


Returns


Returns


Returns


Returns the character at an index Examples


Returns a slice of the string
You can omit the The arguments must be integers or the none constant. If you specify Examples
