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

How to use the IMCOSH function

The IMCOSH function calculates the hyperbolic cosine 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 cosine of a complex number is calculated like this:
cosh(x + yi) = cosh(x)*cos(y) + isinh(x)*sin(y)

 

1. IMCOSH Function Syntax

IMCOSH(inumber)

Back to top

2. IMCOSH Function Arguments

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

Back to top

3. IMCOSH function example

How to use the IMCOSH function

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

Formula in cell D3:

=IMCOSH(C3)

3.1 Explaining formula

Step 1 - Populate arguments

IMCOSH(inumber)

becomes

IMCOSH(C3)

Step 2 - Evaluate the IMCOSH function

IMCOSH(C3)

becomes

IMCOSH("2+2i")

and returns

-1.56562583531574+3.29789483631124i

Back to top