Atan2 Method
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

WorksheetFunction.Atan2 Method

Office 2007
Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between -pi and pi, excluding -pi.


expression.Atan2(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.


NameRequired/OptionalData TypeDescription
Arg1RequiredDoubleThe x-coordinate of the point.
Arg2RequiredDoubleThe y-coordinate of the point.

Return Value


  • A positive result represents a counterclockwise angle from the x-axis; a negative result represents a clockwise angle.
  • Atan2(a,b) equals Atan(b/a), except that a can equal 0 in Atan2.
  • If both x_num and y_num are 0, Atan2 returns an error value.
  • To express the arctangent in degrees, multiply the result by 180/PI( ) or use the Degrees method.

© 2016 Microsoft