Practice free

CSC function

CSC returns the cosecant of an angle in radians, which is 1 divided by the sine. An angle of zero returns a #DIV/0! error because the sine is zero there.

Example

Read it as a sentence: find the cosecant of 1 radian.

Practice this in the app

Syntax

CSC(number)

number (required)
An angle in radians. Must not be zero.

Returns: The cosecant (1 divided by the sine).

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=CSC(0.5) 2.085829643 Positive
=CSC(-0.5) -2.085829643 Negative
=CSC(2) 1.09975017 Larger value
=CSC("0.5") 2.085829643 Text number "0.5"
=CSC(TRUE) 1.188395106 TRUE
=CSC({0.1,0.2}) 10.01668613 Array constant spills
=CSC(0) #DIV/0! Zero
=CSC("abc") #VALUE! Non-numeric text

Watch out for

Where it works

Excel
CSC arrived in Excel 2013. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .