The Excel TAN Function

Related Functions:
COS Function
SIN Function
Tangent of an Angle

For the simple right-angled triangle below, the tangent of the angle θ, is the ratio of the opposite side, o, to the adjacent side, a.

Right-Angled Triangle

I.e. for the triangle above,

Tangent Equation

The trig. ratios are discussed further on the Wikipedia Trigonometric Ratios Page

Basic Description

The Excel TAN function calculates the tangent of a given angle.

The format of the function is :

TAN( number )

Where the number argument is the angle, in radians, that you want to calculate the tangent of.

Converting from Radians to Degrees

If your angle is in degrees, you will need to convert it into radians before supplying it to the Tan function.

The easiest way to do this is to use the Excel Radians function:

=RADIANS( degrees )
An example of this is given below.

Tan Function Examples

Column A of the spreadsheet below, shows examples of the Excel Tan Function, used to calculate the tangent of different angles.

 Formulas:
  A B
1 =TAN( 1.047197551 )  - tan of 1.047197551 Radians
2 =TAN( 0 )  - tan of 0 Radians
3 =TAN( PI()/4 )  - tan of π/4 Radians
4 =TAN( RADIANS( -45 ) )  - tan of -45 Degrees
 Results:
  A
1 1.732050807
2 0
3 1
4 -1

Note that in the above examples:


Further information and examples of the Excel Tan function can be found on the Microsoft Office website.