Excel TAN Function

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

  1. Click on an empty cell (like F5 )
empty cell

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

fx icon in excel

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

insert function tab in excel

4. Select math and trig category

5. Select TAN function

6. Then select ok

excel TAN function

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)

How to use TAN function in excel

Examples of TAN function in Excel

Example 1:

How to use TAN function in excel

You can see examples of TAN function below:

Examples of TAN function in Excel
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)

Errors in TAN function

TAN related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *