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.


Cosh Function Examples

The spreadsheet below shows examples of the Excel Cosh Function used to calculated the hyperbolic cosine of three different numbers.

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

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