Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. HOW TO: Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000

HOW TO: Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000

View products that this article applies to.

Summary

Microsoft Excel 2000 has built-in functions for a large number of trigonometric functions but does not include all such functions. However, you can derive functions from existing functions by using an Excel formula.

Some functions that you can derive from built-in Excel functions include the following:
  • Secant (SEC)
  • Cosecant (CSC)
  • Cotangent (COT)
These functions are the inverse of the cosine, sine, and tangent, respectively.

Formulas for Derived Trigonometric Functions

To calculate these additional functions, use the following formulas, where angle is the measure of the angle in radians:
SEC(angle) = 1/COS(angle)

CSC(angle) = 1/SIN(angle)

COT(angle) = 1/TAN(angle)
For example, to find the cotangent of a 30-degree angle, use the following formula:
=1/TAN(30*PI()/180)
NOTE: Trigonometric functions in Excel must use angles measured in radians rather than in degrees. To convert an angle from degrees to radians, multiply the angle in degrees by PI()/180.

↑ Back to the top

References

For more information about trigonometric functions, click Microsoft Excel Help on the Help menu, type trigonometric functions in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top

Keywords: KB213887, kbhowtomaster, kbhowto

↑ Back to the top

Article Info
Article ID : 213887
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 245