Returns the arctangent of the specified x and y coordinates.
Syntaxis
ATAN2(x_num, y_num)Argumenten
x_numvereist
The x-coordinate of the point.
y_numvereist
The y-coordinate of the point.
The ATAN2 function calculates the angle in radians between the positive x-axis and a point defined by the x and y coordinates. The result is between -pi and pi, excluding -pi.
=ATAN2(1, 1)→0.785398163Calculates the angle for the point (1,1), which is pi/4 radians.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =ATAN2(x_num, y_num) replacing the arguments with your coordinate values.
ATAN takes a single ratio (y/x), whereas ATAN2 takes the x and y coordinates separately to determine the correct quadrant.