The TAN function in Excel calculates and returns the Tangent of a given radians.
TAN(θ) = Opposite / Adjacent = a/b
Tan of the angle θ, is the ratio of the opposite side – a, to the adjacent side – b.
Syntax of TAN Function in Excel
TAN(number)
Where Argument number is angle in radians which you need to calculate the tangent of.
NOTE: If your angle is in degrees, you will need to convert it into radians before supplying it to the TAN Function with the help of Radians function
=RADIANS( degrees )
Example of TAN Function in Excel
Formula
- In Row number 2 and 3 the radians value is passed to the TAN Function
- In row number 4, Angle 60 degree is converted to radians and passed as input to the TAN Function.
- In Row number 5 Radians -π/6 is passed as input to the TAN Function.
- In row number 6, Angle -90 degree is converted to radians and passed as input to the TAN Function.