Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
ASINH
Returns the inverse hyperbolic sine of a number.
Rarely usedDifficulty 1350 · AdvancedUsage rank #315 of 520
When to use it
Inverse hyperbolic sine, defined for all real numbers. A useful log-like transform for data that includes zeros and negatives.
The shape of it
- Syntax
=ASINH(number)
Worked examples
Zero
=ASINH(0) → 0
Zero maps to zero.
One
=ASINH(1) → 0.881373587
LN(1+SQRT(2)).
Negative
=ASINH(-2.5) → -1.647231146
Odd function.
Worth knowing
- The inverse hyperbolic sine transform behaves like LN for large values but handles 0 and negatives, which makes it popular for charting wealth or income.
- ASINH(x) = LN(x+SQRT(x^2+1)).
- SINH inverts it.
Where it goes wrong
- Not the same as 1/SINH.
- For small x it is nearly linear, so it does little to compress small values.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.