Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
IMSINH
Returns the hyperbolic sine of a complex number.
Rarely usedDifficulty 1550 · AdvancedUsage rank #510 of 520
When to use it
The hyperbolic sine of a complex number.
The shape of it
- Syntax
=IMSINH(inumber)
Worked examples
Typical
=IMSINH("4+3i") → -27.0168132580039+3.85373803791938i
A typical result.
Zero
=IMSINH("0") → 0
At zero.
Pure imaginary
=IMSINH("i") → 0.841470984807897i
sinh(i) is i sin(1).
Worth knowing
- sinh(iy) = i sin(y).
- Introduced in Excel 2013.
- Result is text.
Where it goes wrong
- #VALUE! for invalid text.
- #NAME? in Excel 2010 and earlier.
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.