ExcelFlux

ATAN2 function

the arctangent from x- and y-coordinates.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Find direction from horizontal and vertical coordinates. Excel takes the horizontal coordinate first. Equal positive coordinates give 45 degrees.

A worked example from the workbook

RowAB
6InputSecond input
711
822
933
Record 1
=ATAN2(A7,B7)

Expected result0.7853981634

See the inputs and instructions for all 3 examples

Syntax

ATAN2(x_num, y_num)

Copyable formulas

English Excel · en-US
=ATAN2(A7,B7)
Turkish Excel · tr-TR
=ATAN2(A7;B7)

Worked examples

Find direction from horizontal and vertical coordinates. Excel takes the horizontal coordinate first. Equal positive coordinates give 45 degrees.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input Second input
7 1 1
8 2 2
9 3 3
Case Formula Expected result
Record 1 =ATAN2(A7,B7) 0.7853981634
Record 2 =ATAN2(A8,B8) 0.7853981634
Record 3 =ATAN2(A9,B9) 0.7853981634
Microsoft Excel reference