Math & Trig

ASINH Function in Excel

Returns the inverse hyperbolic sine of a number.

Syntax

  • =ASINH(number)

Arguments

  • number (required): Any real number

Examples

  • =ASINH(1) - Inverse hyperbolic sine - Result: 0.881

ASINH in reporting workflows

  • Use absolute references when copying formulas across rows.
  • For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
  • Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

  • Works with any real number

Use cases

  • Hyperbolic functions
  • Engineering
  • Physics

Frequently asked questions

  • What is ASINH in Excel and how does it work? ASINH returns the inverse hyperbolic sine of a number. The syntax is =ASINH(number). Unlike ASIN (which only accepts values between -1 and 1), ASINH accepts any real number. For example, =ASINH(1) returns approximately 0.881. ASINH is the inverse of SINH, meaning SINH(ASINH(x)) = x.
  • What is the difference between ASINH and ASIN? ASIN is the inverse trigonometric sine (works with regular trigonometry) and only accepts values between -1 and 1, returning angles between -π/2 and π/2. ASINH is the inverse hyperbolic sine (works with hyperbolic functions) and accepts any real number, returning any real number. Use ASIN for angles, ASINH for hyperbolic calculations.
  • When should I use ASINH? ASINH is useful in engineering calculations involving hyperbolic geometry, such as catenary curves (suspended cables), transmission line calculations, and certain physics problems. It's also used in signal processing and appears in solutions to differential equations involving hyperbolic functions.
  • Can ASINH handle negative numbers? Yes, ASINH accepts any real number, including negative values. ASINH is an odd function, meaning ASINH(-x) = -ASINH(x). For example, =ASINH(-1) returns approximately -0.881, which is the negative of ASINH(1).
  • How is ASINH related to natural logarithm? ASINH can be expressed in terms of natural logarithm: ASINH(x) = LN(x + SQRT(x^2 + 1)). This relationship is useful for understanding the function's behavior and for calculations in systems that don't have ASINH built-in.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.