Article ID: 213887 - View products that this article applies to.
This article was previously published under Q213887
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:
SEC(angle) = 1/COS(angle)For example, to find the cotangent of a 30-degree angle, use the following formula:
CSC(angle) = 1/SIN(angle)
COT(angle) = 1/TAN(angle)
=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.
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.
Article ID: 213887 - Last Review: September 27, 2003 - Revision: 3.1