Documentation/Calc Functions/IMCSC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

Other languages:

Calc Functions Home | List of functions | Abbreviations

Function name:

IMCSC

Category:

Add-in

Summary:

Calculates the trigonometric cosecant of a complex number. The cosecant is the reciprocal of the sine.

Syntax:

IMCSC(ComplexNumber)

Returns:

Returns a text string giving the complex number that is the cosecant of the complex number passed as argument.

Arguments:

ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, whose cosecant is to be determined. a and b are real numbers.

If ComplexNumber does not have an imaginary part (b equal to 0), the real part can be passed to IMCSC as a number rather than a string.
If ComplexNumber is not a valid complex number, IMCSC reports an invalid argument error (Err:502).

Additional details:

Details specific to IMCSC function

For a complex number of the form a+bi, IMCSC implements the following equation:

However, IMCSC determines if b=0 and in this case simply returns 1/sin(a).

General information about Calc's handling of complex numbers

Note:
For convenience, the information in this subsection is repeated on all pages describing functions that manipulate complex numbers.

A complex number is a number that can be expressed in the form a+bi, where a and b are real numbers and i is a symbol for the imaginary unit, such that i²=−1. a is known as the real part of the complex number and b is known as its imaginary part.
In some disciplines using i to indicate the imaginary unit may be undesirable and, in such cases, the symbol j may be used instead. The functions provided by Calc to process complex numbers can use either i or j.
For additional general background information, visit Wikipedia’s Complex number page.
Within Calc, a complex number is represented as a string expression of the form "a+bi" or "a+bj", where a and b are real numbers. If the complex number happens to be a real number (b=0), then it can be represented as either a string expression or a numeric value. Complex number string expressions should not contain any space characters. Examples of valid Calc complex numbers include "2", -6, "2+3i", "3j", "12.34+56.78i", and "1e+23-1e-22j". Calc would not recognize the strings "1+j2", "i+1", and "i+j" as valid complex numbers.
The representation of the complex numbers in strings can have up to 15 significant digits and scientific style is automatically used if needed (visit Wikipedia’s Scientific notation page for more information). The decimal delimiter in complex number string expressions is always a dot, irrespective of locale setting.

Examples:

Formula	Description	Returns
=IMCSC("1.2-3.4j")	Here the function calculates the cosecant of a complex number that has non-zero real and imaginary parts.	0.0621774637507711+0.024119540185495j
=IMCSC("-i")	Here the function calculates the cosecant of a complex number that has no real part. The result has no real part.	0.850918128239322i
=IMCSC(-1)	Here the function calculates the cosecant of a complex number that has no imaginary part. The result has no imaginary part.	−1.18839510577812
=IMCSC(F1) where cell F1 contains the complex number 2-3j.	Here the function calculates the cosecant of a complex number that is entered in a cell.	0.0904732097532074-0.0412009862885741j

Related LibreOffice functions:

ODF standard:

Section 6.8.10, part 2

Related (or similar) Excel functions:

IMCSC since v.2013.