The TAN function is a Math and Trigonometry function, and its purpose is to return a tangent of a number or angle. In this post, we show you how to use the TAN function in Microsoft Excel.

### What is the TAN formula?

In Microsoft Excel, the formula for the TAN function is:

TAN(number)

The syntax for the TAN function is:

Number: The angle for radians for which you want the tangent.

### What is Math and Trig functions in Excel?

In Microsoft Excel, the Math and Trig functions allow users to do many mathematical calculations including basic arithmetic, sums and products, exponent and logarithms, and trigonometric ratios. The Math and Trig functions are not the only math-related functions in Excel, depending on the math they use; math functions can also be found in the Statistical function and Engineering functions categories.

## How to use the TAN function in Excel

Follow the steps below to use the TAN function in Microsoft Excel:

- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the Enter Key.

Launch **Microsoft Excel**.

Create a table or use an existing table from your files.

Finding a tangent of a particular number; click the cell where you want to place the result.

Type into the cell **=TAN(A2)** and press Enter. The result will be equal to *1.222056*.

If your argument is in the degrees multiply by **PI()/180** or use the Radian function to convert it to radians.

In the cell you want to place the result, type **=TAN(30*PI()/180)** and press Enter. The result is *0.57735*.

If using the Radian function use the formula **=TAN(RADIANS(30))**, press enter. The result is *0.57735*.

There are two other methods to use the TAN function

1] Method one is to click the *fx* button on the top left of the Excel worksheet.

An **Insert Function** dialog box will appear.

Inside the dialog box in the section, **Select a Category**, select *Math and Trigonometry *from the list box.

In the section **Select a Function**, choose the *TAN *function from the list.

Then click *OK.*

*A Function Arguments dialog box will open.*

In the **Number** entry box, input into the entry box cell* A2.*

Then click* OK.*

2] Method two is to click the **Formulas **tab, then click the *Math and Trigonometry *button in the *Function Library* group.

Then select *TAN *from the drop-down menu.

A **Function Arguments** dialog box will open.

We hope this tutorial helps you understand how to use the TAN function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.

**Now read**: How to create a Gauge Chart in Excel.