Microsoft KB Archive/188082

= XL98: How to Find Secant, Cosecant, or Cotangent of an Angle =

Article ID: 188082

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q188082





SUMMARY
Microsoft Excel 98 Macintosh Edition has built-in functions for a large number of Trigonometric functions, but does not include all such functions. However, those not included may be derived from existing functions by using a formula in Microsoft Excel 98 Macintosh Edition.

Some functions that may be derived from built-in Excel functions include:   secant (SEC) cosecant (CSC) cotangent (COT) These functions are the inverse of the cosine, sine, and tangent, respectively. To calculate these additional functions where "angle" is the measure of the angle in radians, use the following formulas:   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: To convert an angle from degrees to radians, multiply the angle in degrees by PI/180.



MORE INFORMATION
For additional information on converting degree angles to radians, please see the following article in the Microsoft Knowledge Base:

41064 XL: Trigonometric Functions Returning Incorrect Values

