In this tutorial, you will learn how to get the tangent of an angle using Excel TAN function in Excel with the formula: =TAN (angle in radians)
As you have noticed the syntax is very simple, you just have to enter the angle in radians. We will also cover the examples of tangent calculation if the angle is in degrees. You will learn how to convert degrees into radians using RADIANS function with syntax.=RADIANS(angle)
In addition, you will learn how to calculate the tangent of an angle using PI function and input about the angle in degrees.
Using Excel’s TAN function
 Get the tangent of an angle in radians
 Calculation of tangent of an angle in degrees
 PI function usage in a calculation of a tangent of an angle in degrees
Get the tangent of an angle in radians
A tangent of an angle is calculated as a ratio between the length of the opposite side and length of the adjacent side of any right triangle.
The tangent of an angle
We can use Excel TAN function to get the tangent of an angle. If the angle is in radians formula syntax will look like:
=TAN(number)
=TAN(C3)
The tangent of an angle in radians
The only part of the formula syntax is number, representing the angle in radians. We can put directly number in a formula or a specific cell with data of the angle in radians.

Calculation of tangent of an angle in degrees
If you want to get the tangent of an angle in degrees, you will have to use the combination of the two functions, TAN and RADIANS. Formula syntax will look like:
=TAN(RADIANS(angle))
=TAN(RADIANS(B4))
Calculation of tangent of an angle in degrees
Angle in degrees is the only part of the RADIANS formula syntax since the RADIANS function is just converting the angle in degrees into radians. The formula output is now suitable for the Excel TAN function since this function is using an angle in radians.

PI function usage in a calculation of a tangent of an angle in degrees
Another way to get the tangent of an angle in degrees is to use the combination of two Excel functions TAN and PI. Formula syntax for this way of calculation is shown below:
=TAN(angle in degrees*PI()/180)
=TAN(B5*PI()/180)
PI function usage in a calculation of a tangent of an angle in degrees
Since Excel TAN function input should be the angle in radians, we should convert degrees into radians. This can be done by multiplying the angle in degrees with PI()/180. The formula result is now adequate input for Excel TAN function, giving the tangent of an angle in degrees using the PI function.
Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free.
Leave a Comment