Creating advanced mathematical calculations

If you are looking for more advanced mathematical calculations, you can use trigonometry functions. For more simple calculations, see Using simple numeric functions.

Below are the available trigonometry functions:

Table 1. Trigonometry functions

Functions

Definition

COS(Number)

Computes the cosine of the entered number, in radians.

ACOS(Number)

Computes the arc cosine of the entered number, in radians.

SIN(Number)

Computes the sine of the entered number, in radians.

ASIN(Number)

Computes the arc sine of the entered number, in radians.

TAN(Number)

Returns the tangent of the entered number.

ATAN(Number)

Returns the angle, in radians, where the tangent is entered in the parameter (between negative PI/2 and positive PI/2

ATAN2(Number,Number)

Returns the angle of the point y/x in radians, when measured counterclockwise from a circle's x axis (where 0,0 represents the center of the circle). The return value is between positive PI and negative PI. The first parameter to ATAN2 is always the y coordinate.