Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Atan2 Method
Collapse the table of content
Expand the table of content

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.

Community Additions

© 2015 Microsoft