Syntax
CSC(number)
| Parameter | Description |
|---|---|
| number | Parameter of the CSC function. |
Examples
Cosecant of 90 degrees
Formula
=CSC(PI()/2)
Returns 1. CSC(90°) = 1/SIN(90°) = 1/1 = 1.
Cosecant of 30 degrees
Formula
=CSC(RADIANS(30))
Returns 2. CSC(30°) = 1/SIN(30°) = 1/0.5 = 2.
Identity check
Formula
=CSC(A1)^2 - COT(A1)^2
Returns 1 for any valid angle. Confirms the identity csc²(x) - cot²(x) = 1.
Common Errors
#DIV/0!
CSC is undefined where SIN equals zero: at 0°, 180°, 360°, etc. (0, π, 2π radians). These return #DIV/0!.
#VALUE!
Non-numeric input returns #VALUE!.
Tips
1/SIN shorthand
CSC(x) = 1/SIN(x). Use whichever is clearer in your formula context.
Trig identity
CSC²(x) = 1 + COT²(x). This parallels the sec²(x) = 1 + tan²(x) identity.
Rare in spreadsheets
CSC is rarely needed in typical spreadsheet work. It's most useful when implementing published scientific or engineering formulas that explicitly use cosecant.
Try CSC in Viztab
Import your data and use CSC with 370+ other formulas. No signup required.
Open Viztab