You are currently offline, waiting for your internet to reconnect

How to Find Secant, Cosecant, or Cotangent of an Angle

This article was previously published under Q188075
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Microsoft Excel has built-in functions for a large number of trigonometricfunctions, but does not include all such functions. However, those notincluded may be derived from existing functions by using a formula inMicrosoft Excel.

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 themeasure 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 followingformula:
NOTE: To convert an angle from degrees to radians, multiply the angle indegrees by PI()/180.
NOTE: Trigonometric functions in Excel must use angles measured in radiansrather than in degrees.

For additional information on converting degree angles to radians, pleasesee the following article in the Microsoft Knowledge Base:
41064 XL: Trigonometric Functions Returning Incorrect Values
For more information about trigonometric functions, click Contents AndIndex on the Help menu, click the Index tab in Excel 97 Help, type thefollowing text
trigonometric functions
and then double-click the selected text to go to the "About math andtrigonometry functions" topic. If you are unable to find the informationyou need, ask the Office Assistant.

Article ID: 188075 - Last Review: 08/17/2005 18:18:38 - Revision: 1.3

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • kbhowto KB188075