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:
The equation used to calculate the hyperbolic cosine is:
The Excel COSH function calculates the hyperbolic cosine (cosh) of a supplied number.
The format of the function is :
Where the number argument is the real number that you want to calculate the cosh of. This can be input to the function either :
Column B of the spreadsheet below, shows examples of the Excel Cosh Function, used to calculate the hyperbolic cosine of three different values.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Further information and examples of the Excel Cosh function can be found on the Microsoft Office website.