logo
excelfunctions.org
bookmarks

ATAN2

Returns the arctangent from x- and y-coordinates.

Math & TrigonometryMath Basics

What it does

Returns the arctangent of the specified x- and y-coordinates.

Syntax

ATAN2(x_num, y_num)

Arguments

  • x_num(number) β€” The x-coordinate.
  • y_num(number) β€” The y-coordinate.

Examples

Polar angle

Calculate angle for point (1, 1).

FORMULA
=ATAN2(1, 1)*180/PI()
RESULT
45
SAMPLE DATA
AB
1XY
211