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
See Also