Using Degrees
The CSC function expects radians. To supply an angle to CSC in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians. For example, to get the CSC of 60 degrees, you can use either formula below:
Explanation
The graph of cosecant, shown above, visualizes the output of the function for angles from 0 to a full rotation. The function has vertical asymptotes within the range [0, 2π] at the points 0, π and 2π where the output diverges to infinity. CSC is the inverse of SIN and can be equivalently defined in the formula below: The relationship between cosecant and sine is visualized by the graph of the two functions shown below:
Graphs courtesy of wumbo.net.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.