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 α
The equation used to calculate the hyperbolic cosine is:
Function Description
The Excel Cosh function calculates the hyperbolic cosine (cosh) of a supplied number.
The syntax 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 following spreadsheet shows the Excel Cosh Function, used to calculated the hyperbolic cosine of three different numbers:
|
Formulas:
|
Results:
|
For further details and examples of the Excel Cosh function, see the Microsoft Office website.
Cosh Function Error
If you get an error from the Excel Cosh Function, this is likely to be the #VALUE! error:
Common Error
| #VALUE! | - | Occurs if the supplied number argument is not recognized as a numeric value. |