The Excel ASINH Function
Inverse Hyperbolic Sine
The asinh function returns the inverse hyperbolic sine. Therefore:
ASINH( SINH( z ) ) = z
The equation used to calculate the inverse hyperbolic sine is:
Function Description
The Excel Asinh function calculates the inverse hyperbolic sine of a supplied number.
The syntax of the function is:
ASINH( number )
Where the number argument is the real number that you want to calculate the inverse hyperbolic sine of.
Excel Asinh Function Examples
The following spreadsheet shows the Excel Asinh Function, used to calculate the inverse hyperbolic sine of three different values:
|
Formulas:
|
Results:
|
For further details and examples of the Excel Asinh function, see the Microsoft Office website.
Asinh Function Error
If you get an error from the Excel Asinh 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. |