Returns the arctangent of the specified x and y coordinates.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
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)Result: 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.