September 23, 2023

How to use IMSINH Function in Excel

The IMSINH function returns the hyperbolic sine of a complex number in x+yi or x+yj text format

Syntax:= IMSINH(inumber)

The IMSINH function syntax has the following arguments:

  • inumber: Required. A complex number for which you want the hyperbolic sine

Example: Let’s look at some Excel IMSINH function examples and explore how to use the IMSINH function as a worksheet function in Microsoft Excel:

IMSINH Function - How to use IMSINH Function in Excel

Syntax:  =IMSINH(A2)

Result:

IMSINH Function in Excel - How to use IMSINH Function in Excel

Based on the Excel spreadsheet above, the following IMSINH examples would return:

Syntax: =IMSINH(A3)
Result: -0.489056259041294-1.40311925062204i

Syntax: =IMSINH(A4)
Result: -183.786961900368-83.1307424083639i

Syntax: =IMSINH(A5)
Result: 3.26893943207955-5.1601436675797i

Syntax: =IMSINH(A6)
Result: -27.0168132580039+3.85373803791938i

Syntax: =IMSINH(A7)
Result: -0.905578362006624i

Syntax: =IMSINH(A8)
Result: -4010.99608272426+571.753643292406i

Syntax: =IMSINH(A9)
Result: 7.74111755324774-26.1865273646092i

Syntax: =IMSINH(A10)
Result: 0.892721514737016+201.713660630601i

Syntax: =IMSINH(A11)
Result: 62.6166729967278+39.8190486246075i

Syntax: =IMSINH(A12)
Result: 4494.30277873999-10054.4786895655j

Syntax: =IMSINH(A13)
Result: 2066770526.262-4412341571.46529i

Note:

  • You can use the complex function to convert real and imaginary coefficients into a complex number.
  • If inumber is a value that is not in the x+yi or x+yj text format, IMSINH returns the #NUM! error value.
  • If inumber is a logical value, IMSINH returns the #VALUE! error value

READ:  How to use IMLN Function in Excel

Leave a Reply

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