## What is TAN function in Excel?

The **TAN **function is one of the math functions of Excel.

It Returns the** tangent of an angle**.

We can find this function in **Math & trig category** of insert function Tab.

## How to use **TAN **function in excel

- Click on an
**empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the **insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **TAN **function

6. Then select **ok**

7. In the function arguments Tab you will see ** TAN **function

8. Number is the** angle in radians** for which you want the **tangent**. Degrees PIO/180 = radians

9. You will see **results **in the formula result ( ** TAN **pi()/2=1.63)

## Examples of **TAN** function in Excel

**Example 1:**

**How to use TAN function in excel**

You can see examples of TAN function below:

**tan**(A2) ----->>>>answer is 0
**tan**(A3) ----->>>>answer is -1.73
**tan**(A4) ----->>>>answer is 1
**tan**(A5) ----->>>>answer is 0.72
**tan**(A6) ----->>>>answer is 0.57

## Python code for TAN function

np.tan(x)

### How to plot Y=**TAN**(X) with python code in excel

**TAN**

```
import numpy as np
from matplotlib import pyplot as plt
def f(x):
return np.tan(x)
x = np.linspace(-2*np.pi, 2* np.pi, 1000)
plt.plot(x,f(x))
plt.ylim(-5,5)
plt.show()
```

## What is the purpose of **TAN** function?

**TAN**

It Returns the** tangent of an angle**.

## What is the Return value of **TAN** function?

**TAN**

It returns a number.

## How many arguments does **TAN** function have?

**TAN**

This function has just **1** Argument.

The **argument **of TAN function is **number**.

Number is the** angle in radians** for which you want the **tangent**. Degrees PIO/180 = radians.

The argument of TAN function is **required **and not optional.

```
TAN(number) = number
```

## Which version of excel supports **TAN** function?

**TAN**

This function is available for all excel **versions **(2003-2019)

## Errors in **TAN** function

**TAN**