The TAN function is a Math and Trigonometry function, and its function is to return a tangent of a quantity or angle. On this publish, we present you the way to use the TAN function in Microsoft Excel.
What’s the TAN method?
In Microsoft Excel, the method for the TAN function is:
TAN(quantity)
The syntax for the TAN function is:
Quantity: The angle for radians for which you need the tangent.
What’s Math and Trig features in Excel?
In Microsoft Excel, the Math and Trig features permit customers to do many mathematical calculations together with fundamental arithmetic, sums and merchandise, exponent and logarithms, and trigonometric ratios. The Math and Trig features usually are not the solely math-related features in Excel, relying on the math they use; math features can be discovered in the Statistical function and Engineering features classes.
How to use the TAN function in Excel
Comply with the steps beneath to use the TAN function in Microsoft Excel:
- Launch Microsoft Excel.
- Create a desk or use an current desk out of your information.
- Place the method into the cell you need to see the end result.
- Press the Enter Key.
Launch Microsoft Excel.
Create a desk or use an current desk out of your information.
Discovering a tangent of a specific quantity; click on the cell the place you need to place the end result.
Sort into the cell =TAN(A2) and press Enter. The end result can be equal to 1.222056.
In case your argument is in the levels multiply by PI()/180 or use the Radian function to convert it to radians.
In the cell you need to place the end result, kind =TAN(30*PI()/180) and press Enter. The result’s 0.57735.
If utilizing the Radian function use the method =TAN(RADIANS(30)), press enter. The result’s 0.57735.
There are two different strategies to use the TAN function
1] Technique one is to click on the fx button on the high left of the Excel worksheet.
An Insert Function dialog field will seem.
Inside the dialog field in the part, Choose a Class, choose Math and Trigonometry from the record field.
In the part Choose a Function, select the TAN function from the record.
Then click on OK.
A Function Arguments dialog field will open.
In the Quantity entry field, enter into the entry field cell A2.
Then click on OK.
2] Technique two is to click on the Formulation tab, then click on the Math and Trigonometry button in the Function Library group.
Then choose TAN from the drop-down menu.
A Function Arguments dialog field will open.
We hope this tutorial helps you perceive how to use the TAN function in Microsoft Excel; when you’ve got questions on the tutorial, tell us in the feedback.
Now learn: How to create a Gauge Chart in Excel.
