How to use the COSH Function in Excel

In this article, we will learn about how to use the COSH function in Excel.

COSH function is built in excel function. Hyperbolic function of COSH defined using the exponential function.

COSH (x) = (ex+ e-x) / 2
Where ex = exponential function, e = 2.71828

The COSH function is hyperbolic Cosine of the input number in radians. The function returns a number.
Syntax:

=COSH (number)

number : input number you want the hyperbolic Cosine of.
Let’s understand this function using it in an example.
007
Here we have values and we need to find its hyperbolic Cosine value.

Use the formula:

=COSH(A2)

A2 : number given as cell reference.
008
The value will calculated using the mathematical formulation stated :
COSh (x) = (e1+ e-1) / 2

Now copy the formula to other cells using the Ctrl + D shortcut key.
009
Excel calculates the Hyperbolic Cosine of a number using the COSH function.

Notes:

  1. The function returns the #VALUE! Error, if the argument to the function is non numeric.
  2. The input number is the angle in radians.
  3. If you want the result in degrees, multiply the result by 180/PI ().
  4. If the argument provided is in degrees, first multiply the number in degrees by PI ()/180 to convert it into radians.

Hope you understood how to use COSH function and referring cell in Excel. Explore more articles on Excel mathematical and trigonometric functions here. Please feel free to state your query or feedback for the above article.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF in Excel 2016

How to use the SUMIF Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.