Author: Oscar Cronquist Article last updated on November 09, 2022

How to use the IMCSCH function

The IMCSCH function calculates the hyperbolic cosecant of a complex number in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

The hyperbolic cosecant of a complex number is calculated like this:

csch(x + yi) = sinh(x)*cos(y) - icosh(x)*sin(y) / (sinh2(x)*cos2(y)+cosh2(x)*sin2(y))

1. IMCSCH Function Syntax

IMCSCH(inumber)

Back to top

2. IMCSCH Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMCSCH function example

How to use the IMCSCH function

The image above demonstrates a formula in cell D3 that calculates the hyperbolic cosecant of a complex number specified in cell C3.

Formula in cell D3:

=IMCSCH(C3)

3.1 Explaining formula

Step 1 - Populate arguments

IMCSCH(inumber)

becomes

IMCSCH(C3)

Step 2 - Evaluate the IMCSCH function

IMCSCH(C3)

becomes

IMCSCH("2+2i")

and returns

-0.107954592221385-0.244687073586957i

Back to top