Related Functions:

The IMCOSH function returns the hyperbolic cosine 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

=IMCOSH(inumber)

Arguments

Argument Description
inumber A complex number for which you want the hyperbolic cosine

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 =IMCOSH(A2) -6.58066304055116-7.58155274274654i Returns the hyperbolic cosine of a complex number, 3+4i
3   =IMCOSH(“3+4i”) -6.58066304055116-7.58155274274654i  
4   =IMCOSH(“2-i”) 2.03272300701967-3.0518977991518i  
5   =IMCOSH(COMPLEX(4,1)) 14.7547011704838+22.963673499193i  

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 hyperbolic cosine of a complex number is calculated as:  

    \[cosh(x+yi) = cosh(x) cos(y) - sinh(x) sin(y)i  \]

See Wikipedia for more information on complex numbers.