# How to Insert Tangents in Excel

Microsoft Excel's host of mathematical functions allow you to insert more than just numbers or letters in spreadsheet cells -- you can perform calculations in them too. The TAN and TANH functions return, respectively, the tangent of a given angle and the hyperbolic tangent of a real number. Both functions can be combined with other functions for more complex and versatile calculation.

#### 1

Click the spreadsheet cell that you want to contain the tangent.

#### 2

Enter the TAN function using the "TAN(r)" format, where "r" is the angle in radians. If it's easier to express the angle in degrees, you can use Excel's RADIANS function to convert it to radians. Thus:

TAN(RADIANS(60))

would return the tangent of a 60-degree angle.

#### 3

Use the very similar TANH function to obtain the hyperbolic tangent of any real number, as in TANH(4) or TANH(-2). The hyperbolic tangent is derived from the hyperbolic sine and cosine -- just as the tangent is derived from the regular sine and cosine. Where the regular tangent intercepts a circle at exactly one point, the hyperbolic tangent instead intercepts a hyperbola. For more information on the hyperbolic functions, see the link in "Resources."

References

Resources

Writer Bio

Theon Weber has been a professional writer and critic since 2006, writing for the Village Voice, the Portland Mercury, and the late Blender Magazine. He was a staff writer at the Web-based Stylus Magazine from 2005 to its closure in 2007.