Excel CSC Function

The Excel CSC function returns trigonometric cosecant of an angle (angle should be in radians).

The CSC function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the CSC function can be used as part of a formula in a worksheet cell.

Syntax

CSC(number)

Parameters

Return Value

Returns the trigonometric cosecant of an angle.

Notes

• If the argument is in degrees, multiply it by PI()/180 or use the RADIANS function to convert it to radians.
• CSC(0) returns #DIV/0! error.
• CSC(n) equals 1/SIN(n).
• If the argument is a non-numeric value, CSC returns #VALUE! error.
• If the argument is outside its constraints, CSC returns #NUM! error.

Example: Using as Worksheet Function

The example below shows how to use the CSC function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=CSC(C5)
Result: #DIV/0!

=CSC(C6)
Result: 1.414

=CSC(C7)
Result: 1

=CSC(C8)
Result: 1.414

=CSC(C9)
Result: 8162276138809540

=CSC(C10)
Result: -1.414

=CSC(C11)
Result: -1

=CSC(C12)
Result: -1.414

=CSC(C13)
Result: -4081138069404770

Example: Using angles in Degrees

To supply an angle to CSC function in degrees, the angle can be multiplied by PI()/180. Alternatively, the angle expressed in degrees can be used in the CSC function by converting it into radians using RADIANS function. For example, to get the CSC of 30 degrees, the following formula can be used:

=CSC(30 * PI()/180)
Result: 2

=CSC(RADIANS(30))
Result: 2