Excel functions / Math
TAN function
The tangent of an angle given in radians.
Syntax
=TAN(number)
Arguments
number: The angle, in radians. Wrap degrees in RADIANS().
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
The height of a tree 20 m away, seen at 35 degrees
A B C D 1 Distance Angle 2 20 35 14.0 In D2:
=A2*TAN(RADIANS(B2))→ 14.0A slope of 45 degrees rises 1 for every 1 across
A B C 1 Degrees 2 45 1 In C2:
=TAN(RADIANS(A2))→ 1
Common mistakes
- Near 90 degrees. The tangent grows without limit as the angle nears 90 degrees, and the result becomes enormous.
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.
- Czech: TG
- Danish: TAN
- Dutch: TAN
- Finnish: TAN
- French: TAN
- German: TAN
- Hungarian: TAN
- Italian: TAN
- Norwegian: TAN
- Polish: TAN
- Portuguese (Brazil): TAN
- Portuguese (Portugal): TAN
- Russian: TAN
- Spanish: TAN
- Swedish: TAN
- Turkish: TAN