Go Back

Learn How to Use the TAN Function in Excel

Read time: 20 minutes

We can find the TANGENT of an angle by using the TAN function and the RADIANS function. This can also be done by using the TAN and PI function.

Figure 1: Result of the TAN function for 30, 45, and 60 degrees

Using the TAN and RADIANS function

The TAN function returns the tangent of an angle that is in RADIANS. Hence, for us to use the TAN function here, we must first convert the angle to RADIANS.



Setting up the Data

We will find the tangent of the following angles by using the TAN function; 30, 45 and 60 degrees.

  • We will place the angles in Column A
  • Our formula will be placed in Column B to display the result

Figure 2: How to use the TAN function

The Result

  • We will input the formula below into Cell B4:


Figure 3: How to use the TAN function

  • We will now press ENTER to obtain the result

Figure 4: Result of the TAN function using Radians

  • We will use the drop-down feature to get the results for 45 and 60 degrees

Figure 5: Result of the TAN function for 30, 45, and 60 degrees

Using the PI function

We can also use the PI function to tackle this. The formula with the PI function is given below:


Figure 6: Using the PI function for 30 degrees

As done before, we will use the drop-down arrow to get the result for 45 and 60 degrees.

Figure 7: Result of the TAN function with the PI function for 30, 45, and 60 degrees

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Im trying to write an equation along the lines tan^-1[((18-12.75)/8.75)-tan(51.534) and the answer should be 33.373 degrees im not sure what the issue is?
Solved by C. A. in 12 mins
I need to know the formula/symbol for tan-1
Solved by X. A. in 27 mins
My summary tab formulas are incorrect in this document. Example: Summary page, $176,379.00 34e, should be the same as 72E on the baseline details tan (134,094.00).
Solved by V. C. in 24 mins

Leave a Comment