ATAN2

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

ATAN2(x,y)

This function can take real numbers as arguments.

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.

Accepts numeric data. Returns numeric data.

ATAN2(A1,E3)

ATAN2(R1C1,R3C5)

ATAN2(1,1) gives the result 0.7853981634

This function is available in product version 1.0 or later.