Documentation/Calc Functions/CSC

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

CSC

Category:

Mathematical

Summary:

Returns the cosecant of the given angle (in radians).

Im-jabber.svg

Note:
This function is available since LibreOfficeDev 3.5.

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 a multiple of PI or π, i.e. {......-2π,-π,0,+π,+2π.....}, the cosecant value is undefined, 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.
  • 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:
Csce.png

Where N is the Number

The figure below illustrates the function CSC.

CSC function

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:

CSCH

SIN

RADIANS

ODF standard:

Section 6.16.3, part 2.

Equivalent Excel functions:

CSC