1. Home
  2. Functions
  3. Math
  4. ATAN2

ATAN2 function

Returns the angle, in radians, between the x axis and the line to the point (x_num, y_num).

Syntax

=ATAN2(x_num, y_num)

Arguments

ArgumentRequiredDescription
x_numRequiredThe x coordinate of the point
y_numRequiredThe y coordinate of the point

How to use ATAN2

ATAN2 takes 2 required arguments. Type =ATAN2( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=ATAN2(1, 1)Result 0.785398163
=ATAN2(-1, -1)Result -2.35619449
=ATAN2(0, 0)Result #DIV/0!

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.