Excel functions / Math
ATAN function
The angle, in radians, whose tangent is the number.
Syntax
=ATAN(number)
Arguments
number: The tangent.
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
The angle of a road that rises 1 in 10
A B C D 1 Rise Run 2 1 10 5.7 In D2:
=DEGREES(ATAN(A2/B2))→ 5.7
Common mistakes
- Direction. ATAN cannot tell a point to the left from one to the right. ATAN2, given x and y separately, can.
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.
- Czech: ARCTG
- Danish: ARCTAN
- Dutch: BOOGTAN
- Finnish: ATAN
- French: ATAN
- German: ARCTAN
- Hungarian: ARCTAN
- Italian: ARCTAN
- Norwegian: ARCTAN
- Polish: ATAN
- Portuguese (Brazil): ATAN
- Portuguese (Portugal): ATAN
- Russian: ATAN
- Spanish: ATAN
- Swedish: ARCTAN
- Turkish: ATAN