The IMCSC function returns the cosecant of a complex number in x+yi or x+yj text format.

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

Syntax

=IMCSC(inumber)

Arguments

Argument Description
inumber A complex number for which you want the cosecant

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2 3+4i =IMCSC(A2) 0.0051744731840194+0.036275889628626i Returns the cosecant of a complex number 3+4i
3   =IMCSC(“3+4i”) 0.0051744731840194+0.036275889628626i  
4   =IMCSC(“2-i”) 0.6354937992539-0.221500930850509i  
5   =IMCSC(COMPLEX(4,1)) -0.597696114081001+0.393153826467774i  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied inumber argument is a logical value
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number

The cosecant of a complex number is defined as the inverse of the sine and is calculated as: 

    \[  cosecant(z) = \frac{1}{sine(z)}  \]

See Wikipedia for more information on complex numbers.