Excel Guides

Deriving a Secant and Cosecant in Excel

To derive a secant and cosecant in Excel, we will use the following formulas:

Secant:

=COS(RADIANS(A2))

Cosecant:

=SIN(RADIANS(A3))

where A2 is the angle in degrees for which we want to find the secant, and A3 is the angle in degrees for which we want to find the cosecant.

We can use these formulas to create a table of values for secant and cosecant, as seen below:

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.
Angle (degrees)SecantCosecant
01.0000000000.000000000
300.8660254040.500000000
450.7071067810.707106781
600.5000000000.866025404