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:

Inverse Hyperbolic Sine Equation
Further information on the inverse hyperbolic functions can be found on Wikipedia

Basic Description

The Excel Asinh function calculates the inverse hyperbolic sine of a supplied number.

The format 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 spreadsheet below shows examples of the Excel Asinh Function, used to calculate the inverse hyperbolic sine of three different values.

 Formulas:
 AB
1numberASINH
20=ASINH( A2 )
3-0.5=ASINH( A3 )
42=ASINH( A4 )
 Results:
 AB
1numberASINH
210
3-0.5-0.481211825
421.443635475

Further information and examples of the Excel Asinh function can be found on 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 is non-numeric.