Summary

The Excel ASINH function returns the inverse hyperbolic sine of a number.

Purpose 

Get inverse hyperbolic sine of number.

Return value 

inverse hyperbolic sine of the number.

Syntax

=ASINH(number)
  • number - The number to get the inverse hyperbolic sine of.

How to use 

The Excel ASINH function returns the inverse hyperbolic sine of a number. Given one as input, the function returns 0.881373587 as output.

=ASINH(1) // returns 0.881373587

Explanation

The inverse hyperbolic sine returns the hyperbolic angle of the point on the unit hyperbola with a y-coordinate equal to the input. For example, given one as input representing the point on the unit hyperbola with a y-coordinate of one, the inverse hyperbolic sine returns the hyperbolic angle of 0.881373587.

=ASINH(1) // returns 0.881373587

Corresponding hyperbolic angle.

Given an input of -2 corresponding to the point on the unit hyperbola with a y-coordinate of negative one, the inverse hyperbolic sine returns the hyperbolic angle of -1.443635475.

=ASINH(-2) // returns -1.443635475

Inverse hyperbolic sine returning a negative angle.

The output of the inverse hyperbolic sine function is visualized in this plot:

Plot of the inverse hyperbolic sine function.

Images courtesy of wumbo.net.

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.