Spread Formula Reference
ATAN2
Formula Functions > Functions A to C > ATAN2

This function calculates the arctangent of the specified x- and y-coordinates.

Syntax

ATAN2(x,y)

Arguments

This function can take real numbers as arguments.

Remarks

The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x, y).

The result is given in radians between –PI and PI, excluding –PI. If you want to convert the result to degrees, multiply the result by 180/PI.

Data Types

Accepts numeric data. Returns numeric data.

Examples

ATAN2(A1,E3)

ATAN2(R1C1,R3C5)

ATAN2(1,1) gives the result 0.7853981634

Version Available

This function is available in product version 1.0 or later.

See Also

ACOS | ASIN | ATAN | TAN | Math and Trigonometry Functions