Summary

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