Returns the arctangent of the specified x and y coordinates.
ไวยากรณ์
ATAN2(x_num, y_num)อาร์กิวเมนต์
x_numจำเป็น
The x-coordinate of the point.
y_numจำเป็น
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.