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

How to use the IMCSC function

The IMCSC function calculates the 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 cosecant of a complex number is calculated like this:
csc(x + yi) = (sin(x)*cosh(y) - icos(x)*sinh(y)) / (sin²(x)*cosh²(y) + icos²(x)*sinh²(y))

1. IMCSC Function Syntax

IMCSC(inumber)

Back to top

2. IMCSC Function Arguments

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

Back to top

3. IMCSC function example

How to use the IMCSC function

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

Formula in cell D3:

=IMCSC(C3)

3.1 Explaining formula

Step 1 - Populate arguments

IMCSC(inumber)

becomes

IMCSC(C3)

Step 2 - Evaluate the IMCSC function

IMCSC(C3)

becomes

IMCSC("2+2i")

and returns

0.244687073586957+0.107954592221385i

Back to top