ASINH function
ASINH returns the inverse hyperbolic sine of a number, reversing SINH. It is rare outside technical models, where it turns a hyperbolic sine value back into the original number.
Example
A
B
C
D
1
0.881373587019543
2
3
Syntax
ASINH(number)
-
number(required) - Any number or a reference to one.
Returns: The inverse hyperbolic sine.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ASINH(0.5) | 0.481211825 | Positive |
=ASINH(0) | 0 | Zero |
=ASINH(-0.5) | -0.481211825 | Negative |
=ASINH(2) | 1.443635475 | Larger value |
=ASINH("0.5") | 0.481211825 | Text number "0.5" |
=ASINH(TRUE) | 0.881373587 | TRUE |
=ASINH("abc") | #VALUE! | Non-numeric text |
=ASINH(1E+300) | #NUM! | Large |
Where it works
- Excel
- ASINH is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .