Excel functions / Math

ATAN function

The angle, in radians, whose tangent is the number.

Syntax

=ATAN(number)

Arguments

When to use it

ATAN gives the angle, in radians, whose tangent is a number: the angle of a slope from its rise over its run. The result is between -90 and 90 degrees; ATAN2 covers the full circle.

Examples

  1. The angle of a road that rises 1 in 10

    ABCD
    1RiseRun
    21105.7

    In D2: =DEGREES(ATAN(A2/B2)) → 5.7

    Try this example

Common mistakes

ATAN in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try ATAN in the playground

Related functions