ASINH function

Overview

ASINH is a function of the Math and Trigonometry category that calculates the inverse hyperbolic sine (hyperbolic arcsine) of a number, returning the hyperbolic angle expressed in radians.

Usage

Syntax

ASINH(number) => asinh

Argument descriptions

• number (number, required). The value whose inverse hyperbolic sine is to be calculated.

Additional guidance

The hyperbolic arcsine function is defined as:

$$\mathrm{asinh}(x)=\ln (x+\sqrt{x^2+1})$$

Returned value

ASINH returns a real number in the range (-∞, +∞) that is the hyperbolic arcsine of the specified value, expressed in radians.

Error conditions

• In common with many other IronCalc functions, ASINH propagates errors that are found in its argument.
• If no argument, or more than one argument, is supplied, then ASINH returns the #ERROR! error.
• If the value of the number argument is not (or cannot be converted to) a number, then ASINH returns the #VALUE! error.
• For more information about the different types of errors that you may encounter when using IronCalc functions, visit our Error Types page.

Details

• The ASINH function utilizes the asinh() method provided by the Rust Standard Library.
• The figure below illustrates the output of the ASINH function.

Examples

See some examples in IronCalc.

Links

• For more information about inverse hyperbolic functions, visit Wikipedia's Inverse hyperbolic functions page.
• See also IronCalc's SINH, ACOSH and ATANH functions.
• Visit Microsoft Excel's ASINH function page.
• Both Google Sheets and LibreOffice Calc provide versions of the ASINH function.