COSHfunction returns the hyperbolic cosine of a given value. The hyperbolic cosine is defined as (ex + e-x) / 2, where x is the given value. This function is most commonly used in mathematical calculations and modeling.
- How to use
- Examples of using
COSHformula not working?
- Similar formulas to
COSH formula with the syntax shown below, it has 1 required parameter:
- value (required):
The value for which to calculate the hyperbolic cosine. Must be a number or a reference to a cell containing a number.
ExamplesHere are a few example use cases that explain how to use the
COSHformula in Google Sheets.
Calculate the hyperbolic cosine of a value
To calculate the hyperbolic cosine of a value in a cell, use the formula
=COSH(A1), where A1 is the cell containing the value.
Calculate the distance between two points in a hyperbolic space
To calculate the distance between two points in a hyperbolic space, use the formula
=ACOSH(COSH(x1)*COSH(x2)-SINH(x1)*SINH(x2)*COS(y1-y2)), where x1, x2, y1, and y2 are the coordinates of the two points in the hyperbolic space.
Calculate the rate of growth of a population
To calculate the rate of growth of a population, use the formula
=LN(COSH(r*t)), where r is the growth rate and t is the time period.
COSHnot working? Here are some common mistakes people make when using the
COSHGoogle Sheets Formula:
Incorrect argument type
The value provided must be a numeric value such as a number or a cell reference that contains a number. If a non-numeric value is provided, an error will occur.
Incorrect argument format
The value provided must be in radians. If the value is in degrees, it must be converted to radians first. To convert degrees to radians, multiply the value by PI()/180 or use the RADIANS function.
Using COS instead of COSH
COS and COSH are different functions. Make sure to use COSH when you want to calculate the hyperbolic cosine.
The following functions are similar to
COSH or are often used with it in a formula:
SINHfunction returns the hyperbolic sine of any real number. The hyperbolic sine is a mathematical function that describes the shape of a hanging cable supported at its ends and acted upon by a uniform gravitational force. In Google Sheets, it is most commonly used in mathematical and statistical formulas.
TANHfunction returns the hyperbolic tangent of a value. It is commonly used in mathematical modeling, such as in statistics, physics, and engineering.
ACOSHfunction returns the inverse hyperbolic cosine of a number. In other words, it calculates the value whose hyperbolic cosine is the specified number. This function is useful for solving mathematical problems involving hyperbolic functions.
ATANHfunction returns the inverse hyperbolic tangent of a value. It is commonly used in mathematical calculations involving hyperbolic functions.
You can learn more about the
COSH Google Sheets function on Google Support.