Documentation/Calc Functions/CSC
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
CSC
Category:
Mathematical
Summary:
Returns the cosecant of the given angle (in radians).
Syntax:
CSC(Number)
Returns:
Returns the (trigonometric) cosecant of Number, the angle in radians. The resultant value is a real number not between -1 and 1, i.e. (-∞,-1] and [+1,+∞).
Arguments:
Number is the real number, or a reference to a cell containing that number, which is the angle in radians whose cosecant value is to be calculated.
If Number is 0, CSC of 0 is not defined hence the function returns a numeric error(#NUM!) value.
Additional details:
- The cosecant of an angle is equivalent to 1 divided by the sine of that angle.
- Mathematically, cosecant of multiples of π, i.e. {......-2π,-π,0,+π,+2π.....} is undefined but the PI() function uses an approximate value of π hence the function doesn't return any error value except for 0.
- To insert an angle in degrees, either multiply the angle by PI()/180 or use the RADIANS function to convert the angle to radians.
- The formula for the CSC function is:
Where N is the Number
The figure below illustrates the function CSC.
Examples:
Formula | Description | Returns |
---|---|---|
=CSC(PI()/4) | cosecant or inverse sine of PI/4 or π/4 radians | 1.4142135623731 |
=CSC(RADIANS(30)) | cosecant of 30° by first converting angle in degrees to radians | 2 |
=CSC(0) | cosecant of 0 radian | #NUM! |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
CSC