IMCSCH Function

Basic Description

The Excel Imcsch function returns the hyperbolic cosecant of a supplied complex number. Note: the Imcsch function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

Syntax: IMCSCH( inumber )

where the inumber argument is a complex number. Note that complex numbers are simply stored as text in Excel. When a text string in the format “a+bi” or “a+bj” is supplied to one of Excel’s built-in complex number functions, this is interpreted as a complex number. Also the complex number functions can accept a simple numeric value, as this is equivalent to a complex number whose imaginary coefficient is equal to 0.

 

Imcsch Function Examples

The spreadsheet below shows 4 different examples of the Imcsch function. Each example uses a different method to supply the complex number to the function.

 Formulas:
A B
1 =IMCSCH( 0.5 )
2 =IMCSCH( “3+0.5i” )
3 2 – i =IMCSCH( A3 )
4 =IMCSCH( COMPLEX( 1, -1 ) )
 Results:
A B
1 1.91903475133494
2 0.0874014937786455 – 0.0479849510697105i
3 2 – i 0.141363021612408 + 0.228375065599687i
4 0.303931001628426 + 0.621518017170429i

Note that, in cell B1 of the above spreadsheet, the supplied inumber argument is the real number 0.5, which is equal to the complex number 0.5+0i.

 

Imcsch Function Errors

If you get an error from the Excel Imcsch Function, this is likely to be one of the following:

#VALUE! Occurs if the supplied inumber argument is a logical value.
#NUM! Occurs if the supplied inumber argument is not recognised as a complex number.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment