Excel functions / Math

TAN function

The tangent of an angle given in radians.

Syntax

=TAN(number)

Arguments

When to use it

TAN gives the tangent of an angle in radians: the side opposite the angle divided by the side next to it. It turns an angle into a slope, and a distance and an angle into a height.

Examples

  1. The height of a tree 20 m away, seen at 35 degrees

    ABCD
    1DistanceAngle
    2203514.0

    In D2: =A2*TAN(RADIANS(B2)) → 14.0

    Try this example

  2. A slope of 45 degrees rises 1 for every 1 across

    ABC
    1Degrees
    2451

    In C2: =TAN(RADIANS(A2)) → 1

    Try this example

Common mistakes

TAN 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 TAN in the playground

Related functions