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.
I.e. for the triangle above,
The Excel TAN function calculates the tangent of a given angle.
The format of the function is:
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.An example of this is given below.
Column A of the spreadsheet below, shows examples of the Excel Tan Function, used to calculate the tangent of different angles.
Note that in the above examples:
Further information and examples of the Excel Tan function can be found on the Microsoft Office website.