How to use the Excel TAN function office 365? – Easy Steps!!
Tags: tousetheexceltanfunc, excel, excelfunctions
Published: 2021-09-02 02:11:34

---
title: How to use the Excel TAN function office 365? – Easy Steps!!
published: true
date: 2021-09-01 10:31:51 UTC
tags: ToUseTheExcelTANFunc,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-excel-tan-function-office-365-easy-steps/
---

 **TAN function** is a **Mathematical function** to calculate the **tangent of the angle of the triangle**. In this tutorial, we will guide you on **how to use the TAN**  **Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## TAN Function Syntax

```
=TAN (number)
```

## Example1

- Firstly, you have to **create a sample data** with **input values**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Sample-data-2.png)<figcaption>Sample data</figcaption>

- Then, you need to find the **Tangent value of the Angle**.
- Now, you have to use the following **formula** given below.

```
=TAN(A2/B2)
```

**A2/B2:** Adjacent side of the angle is divided by the opposite side of the angle.

![](https://geekexcel.com/wp-content/uploads/2021/09/TAN-Function-1024x280.png)<figcaption>TAN Function</figcaption>

- After that, if you have an **angle in degrees** , and you need to find the **tangent of that angle**.
- Now, you need to use the following **formula** given below.

```
=TAN(RADIANS(30) 
```

![](https://geekexcel.com/wp-content/uploads/2021/09/Tangent-of-the-angle-1024x281.png)<figcaption>Tangent of the angle</figcaption>

- Finally, you can use another **formula** to find the **tangent of that angle**.

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

![](https://geekexcel.com/wp-content/uploads/2021/09/Another-method-1024x319.png)<figcaption>Another method</figcaption>

## Example2

- Firstly, you have to **create a sample data** with **input values**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Sample-data-3.png)<figcaption>Sample data</figcaption>

- Then, you need to find the **Tangent value of the Angle**.
- Now, you have to use the following **formula** given below.

```
=TAN(A2/B2)
```

**A2/B2:** Adjacent side of the angle is divided by the opposite side of the angle.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-TAN-Function-1024x285.png)<figcaption>TAN Function</figcaption>

- After that, if you have an **angle in degrees** , and you need to find the **tangent of that angle**.
- Now, you need to use the following **formula** given below.

```
=TAN(RADIANS(30) 
```

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Tangent-of-the-angle-1024x283.png)<figcaption>Tangent of the angle</figcaption>

- Finally, you can use another **formula** to find the **tangent of that angle**.

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

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Another-method-1024x372.png)<figcaption>Another method</figcaption>

**Check this too:**

- [TANH Function](https://geekexcel.com/how-to-use-the-tanh-function-in-excel-office-365/)
- [ATANH Function](https://geekexcel.com/how-to-use-the-atanh-function-in-excel-office-365/)
- [IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)

## Closure

We hope that this short tutorial gives you guidelines to **use the TAN Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[How to use the ATANH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-atanh-function-in-excel-office-365/)**
- **[How to use ASIN Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-asin-function-in-microsoft-excel-365/)**
- **[use the F.DIST function in Excel office 365](https://geekexcel.com/how-to-use-the-f-dist-function-in-excel-office-365/)**
- **[How to use the ASINH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-asinh-function-in-excel-office-365/)**
- **[How to use the ACOSH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-acosh-function-in-excel-office-365/)**