The **TAN **function is in the **Trigonometry Functions** list under the **Math and Trig Functions** category that calculates the slope of a tangent of an angle of any triangle. We have other trigonometric functions available in Excel. In this article, we will discuss the use of the Excel **TAN **Function.

From the above image, you get a brief idea about the use of the **TAN **function in Excel.

**Table of Contents**hide

**Download Practice Workbook**

Download the following practice workbook to exercise while you are reading this article.

**Introduction to TAN Function**

**Function Objective:**

The objective of this function is to get the tangent of an angle.

**Syntax:**

**=TAN(number)**

**Argument:**

ARGUMENT | REQUIRED/OPTIONAL | EXPLANATION |
---|---|---|

number |
REQUIRED |
The angle for which we want to get the tangent. |

**Returns:**

The return will be a tangent value.

**Available in:**

Excel for Microsoft 365, Microsoft 365 for Mac, Excel for the web Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel for Mac 2011, Excel Starter 2010.

**Note:**

Our arguments must be in radians. If the argument is in the degree we must multiply it by **Pi()/180** or use the **RADIANS **function.

**What is the Tangent Ratio in Trigonometry?**

The **tangent **or **tan **ratio comes from the tangent line of the trigonometry named **Tangent**. **Sine and Cosine** are also some trigonometric ratios. The **tan ratio **is based on a right-angle triangle. It is defined as the ratio of the opposite arm and the adjacent arm of the right angle.

So, the tangent angle can be expressed in the following way.

Tangent is also expressed as the ratio of Sine and Cosine.

**6 Examples of Using the TAN Function in Excel**

Here, we will show some examples of how to use the **TAN **function in Excel.

**1. Use the TAN Function with Radians**

In this example, we will show how to use the **TAN **function with radians. Here, we have taken a data set that consists of radian values.

** **

We can use these radians directly in the **TAN **function. Now, follow the steps below.

**Step 1:**

- Click on
**Cell C5**. - Now type the following formula-

`=TAN(B5)`

**Step 2:**

- Now, press
**Enter**.

We get the slope of a tangent at **0 **radians.

**Step 3:**

- Pull the
**Fill Handle**icon all the way.

We get the tangent value of all the radians mentioned here.

**2. Use PI Function with TAN Function**

Here we will use **the PI function** with the **TAN **function.

In our data set all the values are in degrees.

**Step 1:**

- We will multiply this data by
**PI()/180**to convert in radians and apply the**TAN**function with the formula:

`=TAN(B5*PI()/180)`

**Step 2:**

- Now, press the
**Enter**.

**Step 3:**

- Drag the pull
**Fill Handle**icon to the last cell.

Here, we get the slope of the tangents against our input data.

**Note:****######** refers that we get infinite values for tangents 90, 270 degrees.

**3. Use RADIAN Function with TAN Function**

Here we will use the **RADIANS** function with the **TAN **function. The **RADIANS **function is used here as our data is in degree.

We will consider the below data for this example.

Here, we need to convert the degrees into radians.

**Step 1:**

- Go to
**Cell C5**.

We will coincide the **RADIANS **function with the **TAN **function.

- Write the following formula:

`=TAN(RADIANS(B5))`

**Step 2:**

- Now, press
**Enter**.

** **

**Step 3:**

- Now, pull the
**Fill Handle**icon towards the last cell.

We get the slope for the tangents for all the data taken as degrees.

**Note:****######** indicates that we get infinite values for tangents 90, 270 degrees.

**Similar Readings**

**How to Use Excel QUOTIENT Function (4 Suitable Examples)****VBA EXP Function in Excel (5 Examples)****How to Use SIN Function in Excel (6 Easy Examples)****44 Mathematical Functions in Excel (Download Free PDF)****How to Use LN Function in Excel (9 Examples)**

**4. Calculate the Height of a Chimney Using Excel TAN Function**

In this example, we will consider a chimney that can be from a distance of 100 m at an angle of 32°. We will find out the height of the chimney here.

We already know that,

**Tangent angle = Opposite Side/Adjacent Side**

Here, we have the data of a chimney below.

**Step 1:**

- Now, we will apply the below formula to find the height.

`=C5*TAN(RADIANS(C6))`

Here, we multiplied the perpendicular by the tangent angle.

**Step 2:**

- Finally, press
**Enter**.

Here, we get the height of a chimney by applying the **TAN** function.

**5. Find the Distance of Two Points from an Aircraft Using TAN Function**

This example is based on an aircraft.

We assume that an aircraft is flying at a height of 400 m. Now, two points A and B are in the direction of the aircraft with angles 45° and 52° respectively. Now, we find out the distance between A and B.

Data presentation of this example is below:

**Step 1:**

- Click on
**Cell C6**. - Enter the following formula-

`=C5*TAN(RADIANS(C8))`

**Step 2:**

- Then, press
**Enter**.

**Step 3:**

- Apply the same formula by changing the corresponding argument at
**Cell C7.** - Then press
**Enter**.

**Step 4:**

- Write the subtraction formula at
**Cell C10**. The formula is:

`=C7-C6`

**Step 5:**

- Then, press
**Enter**.

The above picture shows the distance between the two points.

**6. Calculate the Area of a Trapezoid Using Excel TAN Function**

In this example, we will show how to find the length of the arms of the trapezoid.

We will consider the data in the following image for this example.

We will find the area of the trapezoid. That is-

**Step 1:**

- Go to
**Cell C6**. - Get the value of
**‘a’**by applying the following formula-

`=C8*TAN(RADIANS(C10))`

**Step 2:**

- Then, press
**Enter**.

**Step 3:**

- Now, get the value of applying the following formula at
**Cell C7.**

`=C5+2*C6`

**Step 4:**

- Then press
**Enter**.

**Step 5:**

- Now, we will find the area of the trapezium.
- Apply the following formula to
**Cell C11**.

`=((C5+C7)/2)*C8`

**Step 6:**

- Then press
**Enter**.

This is the area of the trapezium.

**Things to Remember**

- The input data must be in radians format.
- If the input data is degree format. Then first convert to radians format and apply the
**TAN**function.

**Conclusion**

In this article, we described how to use the **TAN **function in Excel. I hope this will satisfy your needs. Please have a look at our website **ExcelDemy.com** and give your suggestions in the comment box.