GET ARCTAN Value using ATAN Function in Excel

The ATAN function in Excel calculates the arctan (inverse of Tan) of a given number and returns the angle in radians between 0 and π. Arctan is inverse of tan.

Trigonometric Function in ExcelARCTAN(a/b)= θ

Arctan of the opposite side – a, divided by the adjacent side – b equal to the angle θ.


Syntax of ATAN Function in Excel


Where Argument number is a value between -1 and 1, which you need to calculate the arctan.


Example of ATAN Function in Excel


ATAN Function in Excel

  • From Row number 2 to 5 ATAN is calculated in radians for value between -1 and 1 that is being passed as input to the ATAN Function.
  • In row number 6, ATAN is calculated in degree for the value 1 which is 45 degree

Note: if you want the value of ATAN Function to be calculated in degrees, then convert it in degrees using DEGREES Function as shown in 6th row.


ATAN Function in Excel 2

previous-small ATAN Function in Excel                                                                                                           next_small ATAN Function in Excel

DataScience Made Simple