Wauvel

Excel like a finance pro.

← The library

Engineering function

IMCSCH

Returns the hyperbolic cosecant of a complex number.

Rarely usedDifficulty 1550 · AdvancedUsage rank #507 of 520
Practice · 2 questions →

When to use it

The hyperbolic cosecant of a complex number.

The shape of it

Syntax
=IMCSCH(inumber)

Worked examples

  • Typical

    =IMCSCH("4+3i") → -0.036275889628626-0.0051744731840194i

    A typical result.

  • Real

    =IMCSCH("1") → 0.850918128239322

    A real input gives csch(1).

  • Pure imaginary

    =IMCSCH("i") → -1.18839510577812i

    csch(i) is -i/sin(1).

Worth knowing

  • 1/IMSINH.
  • Introduced in Excel 2013.
  • Result is text.

Where it goes wrong

  • #NUM! at zero.
  • #NAME? in Excel 2010 and earlier.

Related

CONVERTBIN2DECDEC2BINHEX2DECDEC2HEXDELTA

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.