Related Functions:

The CSC function returns the cosecant of an angle specified in radians.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=CSC(number)

Arguments

Argument Description
number The angle, in radians, for which you want the cosecant

  The absolute value of number must be less than 2^27

Examples

  A B C
1 Formula Result Notes
2 =CSC(15) 1.538 Returns the cosecant of 15
3 =CSC(-6) 3.578899547 Returns the cosecant of -6
4 =CSC(RADIANS(45)) 1.414213562 Returns the cosecant of 45 degree angle

Note: If the angle is in degrees, you need to be convert it to radians before supplying it to the CSC function. You can convert it, using the RADIANS function: =RADIANS(degrees)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument is not recognized as a numeric value
#NUM! Occurs if the supplied number argument is less than -2^27 or is greater than 2^27
#DIV/0! Occurs if the supplied number argument is equal to zero

trigonometry_triangleThe cosecant is the reciprocal of sine. For the simple right-angle triangle at right, the cosecant of angle A is equal to the hypotenuse (h), divided by the opposite side (a). The formula for calculating cosecant is:  

    \[   csc(A) = \frac 1{sin(A)}   \]

See Wikipedia See Wikipedia for more information on Trigonometric Ratios.