Tips for Spreadsheets

*Summary: Use Excel to perform sine, cosine, tangent, and other trigonometric functions.*

Microsoft Excel 2003 has many built-in trigonometric functions:

**=sin(ANGLE)**

Returns the sine of *ANGLE*

**=cos(ANGLE)**

Returns to cosine of *ANGLE*

**=tan(ANGLE)**

Returns the tangent of *ANGLE*

By default, the angle is measured in radians; to convert an angle measurement from degrees to radians, use the **=radians(ANGLE)** function.

Excel also has the hyperbolic trigonometric functions:

**=sinh(ANGLE)**

Hyperbolic sine of *ANGLE*

**=cosh(ANGLE)**

Hyperbolic cosine of *ANGLE*

**=tanh(ANGLE)**

Hyperbolic tangent of *ANGLE*

Excel does *not* include the secant, cosecant, or cotangent functions. However, these can be figured by using the basic trigonometric functions.

If you have the result of a trigonometric function and want to find the angle (in radians) that you would need to get that result, use the inverse functions:

**=asin(SINE)**

Inverse sine of *SINE*

**=acos(COSINE)**

Inverse cosine of *COSINE*

**=atan(TANGENT)**

Inverse tangent of *TANGENT*

**=asin(HYPERBOLICSINE)**

Inverse hyperbolic sine of *HYPERBOLICSINE*

**=acosh(HYPERBOLICCOSINE)**

Inverse hyperbolic cosine of *HYPERBOLICCOSINE*

**=ATANH(HYPERBOLICTANGENT)**

Inverse hyperbolic tangent of *HYPERBOLICTANGENT*

To obtain the angle in degrees, enclose the above functions in the **=degree()** function,

For example:

**=degree(asin(SINE))**

Returns the angle, in degrees, of the inverse sine of *SINE*

Add: Del.icio.us | Digg | Furl | My Yahoo!

*Last Modified on: July 13, 2008, at 12:04 A.M. EDT*

Return to the Microsoft Excel 2003 Functions and Formulas page.

Search the Site: