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
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?
It Returns the tangent of an angle.
What is the Return value of TAN function?
It returns a number.
How many arguments does TAN function have?
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?
This function is available for all excel versions (2003-2019)