The Excel ACOSH Function


Inverse Hyperbolic Cosine

The acosh function returns the inverse hyperbolic cosine. Therefore,

ACOSH( COSH( z ) ) = z

The equation used to calculate the inverse hyperbolic cosine is:

Inverse Hyperbolic Cosine Equation

Further information on the inverse hyperbolic functions can be found on Wikipedia


Basic Description

The Excel ACOSH function calculates the inverse hyperbolic cosine of a supplied number.

The format of the function is :

ACOSH( number )

Where the number argument is a positive real number, which must be greater than or equal to 1, and which you want to calculate the inverse hyperbolic cosine of.

The number argument can be input to the function either :

- directly
- as a value returned from another function or formula, or
- as a reference to a cell containing a value

Excel Acosh Function Examples

Column B of the spreadsheet below, shows examples of the Excel Acosh Function, used to calculate the inverse hyperbolic cosine of three different values.

 Formulas:
  A B
1 number ACOSH
2 1 =ACOSH( A2 )
3 2.5 =ACOSH( A3 )
4 5 =ACOSH( A4 )
 Results:
  A B
1 number ACOSH
2 1 0
3 2.5 1.566799237
4 5 2.29243167

Further information and examples of the Excel Acosh function can be found on the Microsoft Office website.


Acosh Function Common Errors

If you get an error from the Excel Acosh Function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if the supplied number argument is less than 1
#VALUE! - Occurs if the supplied number argument is nonnumeric
Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net