Returns the arctangent of the specified x and y coordinates.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
ATAN2(x_num, y_num)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)Kết quả: 0.785398163
Calculates the angle for the point (1,1), which is pi/4 radians.
ATAN takes a single ratio (y/x), whereas ATAN2 takes the x and y coordinates separately to determine the correct quadrant.