TAN()

Syntax. TAN(number)

Definition. This function returns the tangent of an angle.

Argument

  • number (required) The angle in radians for which you want the tangent

Background. In a right triangle, the ratio between the opposite leg and the adjacent leg depends on the apex angle. The ratio of the opposite leg of an angle and the adjacent leg is the tangent (tan) of an angle.

image with no caption

The TAN() function requires radians for calculations. If the angle is specified in degrees, you have to multiply the angle by PI()/180 or convert it with the RADIANS() function.

If angle α in an unit circle (c = 1) increases between 0° and 90°, the tangent increases between 0 and ∞ ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.