ExcelFunctions.net Logo

The Excel ASINH Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Asinh-Function
Search this site:
Custom Search
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 sinh of. This 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

Examples

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

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Asinh Function
 Results:
Excel Asinh Function Results

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






Valid XHTML 1.0 Transitional

Disclaimer Privacy Policy

Copyright © 2008-2011 ExcelFunctions.net