- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - ATAN Function
Description
The ATAN function returns the arctangent, or inverse tangent, of a number. The returned angle is given in radians between -π/2 and +π/2. The arctangent is the angle whose tangent is number.
Syntax
ATAN (number)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The tangent of the angle you want. | Required |
Notes
If you want the angle returned by the ATAN Function to be expressed in degrees, you can convert it,
using the Excel Degrees Function (=DEGREES (radians))
or, by multiplying it by 180/PI()
If the specified number is not recognized as a numeric value, ATAN returns #VALUE! error
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements