Excel: ATan2 Function

In Excel, the ATan2 function returns the arctangent (in radians) of (x,y) coordinates.

The syntax for the ATan2 function is:

ATan2( x-coordinate, y-coordinate )

x-coordinate is the x-coordinate of a point.

y-coordinate is the y-coordinate of a point.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=ATan2(A1, A2) would return 0.674740942

=ATan2(A2, A3) would return -0.643501109

=ATan2(1, -9) would return -1.460139106

=ATan2(0.2, 0) would return 0

=ATan2(0, 0) would return #DIV/0!