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.
