IMSINH

Formulas / IMSINH
Calculate the hyperbolic sine of a complex number.
IMSINH(inumber)
  • inumber - required, complex number

Examples

  • =IMSINH("4+3i")

    The function returns the inverse hyperbolic sine of a complex number. For example, the formula returns the inverse hyperbolic sine of 4+3i, which is 1.76274717403908.

  • =IMSINH(5)

    The function can also be used to calculate the inverse hyperbolic sine of a real number. The formula returns the inverse hyperbolic sine of 5, which is 3.62686040784701.

  • =IMSINH(SINH(5))

    The function can be used in combination with other Sourcetable functions. For example, the formula returns the inverse hyperbolic sine of the hyperbolic sine of 5, which is 5.

  • =IMSINH(A1:A3)

    The function can also be used to calculate the inverse hyperbolic sine of a range of cells. For example, the formula returns the inverse hyperbolic sine of the values in cells A1, A2 and A3.

Summary

The IMSINH function is a Sourcetable function introduced in Excel 2013 that calculates the hyperbolic sine of a complex number.

  • The IMSINH function was introduced in Excel 2013 and it calculates the hyperbolic sine of a complex number.
  • The complex number functions can accept a numeric argument.


Frequently Asked Questions

What is the IMSINH function?
The IMSINH function is a mathematical function that calculates the hyperbolic sine for a complex number. It takes a complex number as an argument, which must be in x+yi or x+yj text format.
What does the IMSINH function return?
The IMSINH function returns the hyperbolic sine of the complex number.
What is the format of the complex number?
The complex number must be in x+yi or x+yj text format.
What happens if the argument is a logical value?
The IMSINH function returns an error if the argument is a logical value.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV