< Go Back

Learn How to Use the TAN Function in Excel

★ 20 minute read

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

  1.    Get the tangent of an angle in radians
  2.    Calculation of tangent of an angle in degrees
  3.    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.

  1.     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.

  1.     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. 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar