ATAN function
ATAN takes a tangent, which is a slope, and returns the matching angle in radians, between -PI/2 and PI/2. For a full-circle angle from x and y coordinates, use ATAN2 instead.
Example
Read it as a sentence: find the angle, in radians, whose tangent is 1.
A
B
C
D
1
0.785398163397448
2
3
Syntax
ATAN(number)
-
number(required) - A tangent value.
Returns: The angle in radians, between -PI/2 and PI/2.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ATAN(0.5) | 0.463647609 | Positive |
=ATAN(0) | 0 | Zero |
=ATAN(-0.5) | -0.463647609 | Negative |
=ATAN(2) | 1.107148718 | Larger value |
=ATAN("0.5") | 0.463647609 | Text number "0.5" |
=ATAN(TRUE) | 0.785398163 | TRUE |
=ATAN("abc") | #VALUE! | Non-numeric text |
=ATAN(Data!E4) | #DIV/0! | Error cell propagates |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
2
abc
3
TRUE
4
=1/0
Data
Watch out for
- For a full-circle angle from x and y coordinates use ATAN2 instead.
Where it works
- Excel
- ATAN is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .