The Excel COSH Function

Hyperbolic Functions

The basic hyperbolic functions, cosh, sinh and tanh are related to the equilateral hyperbola, x2-y2=1.

If the area between a line through the origin, the x-axis, and the hyperbola x2-y2=1 has area α/2, then:

  • cosh α is the x coordinate of the intersection between the line through the origin and the hyperbola x2-y2=1
  • sinh α is the y coordinate of the intersection between the line through the origin and the hyperbola x2-y2=1
  • tanh α is equal to sinh α / cosh α
Hyperbolic Functions cosh and sinh

The equation used to calculate the hyperbolic cosine is:

Hyperbolic Cosine Equation

Basic Description

The Excel COSH function calculates the hyperbolic cosine (cosh) of a supplied number.

The format of the function is :

COSH( number )

Where the number argument is a real number that you want to calculate the hyperbolic cosine of. This can be input to the function either:


Cosh Function Examples

The spreadsheet below, shows three examples of the Excel Cosh Function.

 Formulas:
Examples of use of the Excel Cosh Function
 Results:
Excel Cosh Function Results

Further information and examples of the Excel Cosh function can be found on the Microsoft Office website.