PC & Mobile

How to use the TAN function in Microsoft Excel

The TAN function is a Math and Trigonometry function, and its function is to return a tangent of a quantity or angle. On this submit, we present you ways to use the TAN function in Microsoft Excel.

What’s the TAN formulation?

In Microsoft Excel, the formulation 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 capabilities in Excel?

In Microsoft Excel, the Math and Trig capabilities permit customers to do many mathematical calculations together with primary arithmetic, sums and merchandise, exponent and logarithms, and trigonometric ratios. The Math and Trig capabilities aren’t the solely math-related capabilities in Excel, relying on the math they use; math capabilities may also be discovered in the Statistical function and Engineering capabilities classes.

How to use the TAN function in Excel

Comply with the steps under to use the TAN function in Microsoft Excel:

  1. Launch Microsoft Excel.
  2. Create a desk or use an present desk out of your information.
  3. Place the formulation into the cell you need to see the consequence.
  4. Press the Enter Key.

Launch Microsoft Excel.

Create a desk or use an present desk out of your information.

Discovering a tangent of a selected quantity; click on the cell the place you need to place the consequence.

Sort into the cell =TAN(A2) and press Enter. The consequence will probably 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 consequence, kind =TAN(30*PI()/180)  and press Enter. The result’s 0.57735.

If utilizing the Radian function use the formulation =TAN(RADIANS(30)), press enter. The result’s 0.57735.

There are two different strategies to use the TAN function

1] Methodology one is to click on the fx button on the prime 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 listing field.

In the part Choose a Function, select the TAN function from the listing.

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] Methodology 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 have questions on the tutorial, tell us in the feedback.

Now learn: How to create a Gauge Chart in Excel.

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button