Parameters

The following parameters are available.

Action

Result

Operands

One numerical operand per operation for the "Square" and "Square root" calculation types, otherwise two numerical operands.

Source: Source table, constants, user input or incoming values from other operators.

Data type: Number

Specification: Mandatory

Calculation type

 

Addition (+)

Adds two columns row by row

Subtraction (-)

Subtracts 2 columns row by row

Division (/)

Divides the first column by the second column

Multiplication (*)

Multiplies two columns row by row

Percent (%)

Row by row, multiplies the second column with the percent value of the first column

Square (x²)

Calculates the square of a column

Root

Calculates the square root of a column

Sine (sin)

Calculates for a column the sine value of an angle in degrees

Cosine (cos)

Calculates for a column the cosine value of an angle in degrees

Tangent (tan)

Calculates for a column the tangent value of an angle in degrees

Arcsine (asin)

Calculates for a column the arcsine of an angle in degrees

Arccosine (acos)

Calculates for a column the arccosine of an angle in degrees

Arctangent (atan)

Calculates for a column the arctangent of an angle in degrees

Logarithm (lg)

Calculates for a column the common logarithm

Logarithm (ln)

Calculates for a column the natural logarithm

Power (exp)

Calculates for a column S1 the S2nd power of S1 (S1 to the power of S2)

Minimum (min)

Calculates the minimum of column 1 and column 2

Maximum (max)

Calculates the maximum of column 1 and column 2

Absolute value (abs)

Calculates for a column the absolute value

The default value: Addition (+)

Specification: Mandatory

You need to specify the source values for the trigonometric functions sin, cos, tan, asin, acos, and atan in degrees.