Purpose
Return value
Syntax
=IMCSC(complex_num)
- complex_num - The complex number in the form “x+yi”.
Using the IMCSC function
The Excel IMCSC function returns the cosecant of a complex number. For example, given “4+3i” as input, the function returns “-0.075489833+0.064877471i” as output.
=IMCSC("4+3i") // returns -0.075489833+0.064877471i
Explanation
In math, the complex cosecant function is the reciprocal of the complex sine function .
In Excel, the complex cosecant function is equivalent to the following formula.
=IMDIV(COMPLEX(1,0),IMSIN(z)) // equivalent to IMCSC(z)
Purpose
Return value
Syntax
=IMCSCH(complex_num)
- complex_num - The complex number in the form “x+yi”.
Using the IMCSCH function
The Excel IMCSCH function returns the hyperbolic cosecant of a complex number. Given “1+1.5707963267949i” as input, the function returns “-1.72324E-15-0.648054274i” as output.
=IMCSC(COMPLEX(1, PI()/2)) // returns -1.72324E-15-0.648054274i
Explanation
The complex hyperbolic cosecant function is the reciprocal of the complex hyperbolic sine function.
In Excel, the function’s output is equivalent to the following formula.
=IMDIV(1,IMSINH(z)) // equivalent to IMCSCH(z)
