Tips.Net > ExcelTips Home > Formulas > Deriving a Secant and Cosecant
Deriving a Secant and Cosecant
Summary: Two rather common trigonometric functions are secants and cosecants. Excel doesn’t provide functions to calculate these, but you can use a formula to derive them, as described here. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
Excel includes many built-in functions that allow you to use a wide range of trigonometric functions. Two that are not included, however, are functions for determining a secant and a cosecant. Let's assume that an angle value, in radians, is stored in cell B7. If you need to know the secant of the angle, you can use the following formula:
=1/COS(B7)
Likewise, if you need to know the cosecant of the angle, the following formula will do the trick:
=1/SIN(B7)
Tip #2455 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
Check out Timesheet Templates today!
Fast Answers!
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site