Advanced Options

Function

Operator / Symbol

Syntax

Explanation

Example

Multiplication

*

n1*n2

Multiply values in two columns.

A2*A3 (This gives the result in the specified cell after multiplying the values in Column 2 and Column 3.)

Division

/

n1/n2

Divide values in two columns.

A2/A3 (This gives the result in the specified cell after dividing the value in Column 2 by the value in Column 3.)

Subtraction

-

n1-n2

Subtract values in two columns.

A2-A3 (This gives the result in the specified cell after subtracting the value in Column 2 from the value in Column 3.)

Addition

+

n1+n2

Add values in two columns.

A2+A3 (This gives the result in the specified cell after adding the values in Column 2 and Column 3.)

Log

Math.log (value1)

Math.log (n1)

To find the log of a result, use the syntax [Math.log (result)].

Math.log (record [8])/Math.LN10

Exponent

Math.exp (value1)

Math.exp (n1)

To find the exponent of a number.

A1*(Math.exp ((A2*A3*A4*A5)/ (A6*A7)))

Square Root

Math.sqrt (value1)

Math.sqrt (n1)

To find the square root of a particular column.

Math.sqrt (A5)

Absolute Value

Math.abs (value1)

Math.abs (n1)

Given the absolute value of number

Math.abs (A3)

Arc Cosine

Math.acos(value1)

Math.acos(n1)

Gives the arc cosine of a number

Math.acos(A3)

Arc Sine

Math.asin(value1)

Math.asin(n1)

Gives the arc sine of a number.

Math.asin(A3)

Arc Tangent

Math.atan(value1)

Math.atan(n1)

Gives the arc tangent of a number.

Math.atan(A3)

Arc Tangent

Math.atan2(value1, value2)

Math.atan2(n1,n2)

Gives the arc tangent of a number divided by another number.

Math.atan2(A1,B1)

Ceiling

Math.ceil(value1)

Math.ceil(n1)

Gives an integer closest to a number and not less than that number.

Math.ceil(A3)

Cosine

Math.cos(value1)

Math.cos(n1)

Gives the cosine of a number.

Math.cos(A3)

Power

Math.pow(value1, value2)

Math.pow(n1,n2)

Gives the value of a number to the power of another number.

Math.pow(A1,B1)

Sine

Math.sin(value1)

Math.sin(n1)

Gives the sine of a number.

Math.sin(A3)

Tangent

Math.tan(value1)

Math.tan(n1)

Gives the tangent of a number.

Math.tan(A3)