This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - 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



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Trigonometric Functions.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.