The Excel ATAN function calculates the arctangent (i.e. the inverse tangent) of a given number, and returns an angle, in radians, between -π/2 and +π/2.
The syntax of the function is:
Where the number argument is the value, for which you want to calculate the arctangent.
Converting from Radians to DegreesAn example of this is provided below.
The following spreadsheet shows the Excel Atan Function, used to calculate the arctangent of four different values.
Note that in cell A4, the Excel Degrees function is used to convert the calculated angle from radians to degrees.
For further information and examples of the Excel Atan function, see the Microsoft Office website.
If you get an error from the Excel Atan Function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if the supplied number argument is non-numeric.|