The Excel IMSINH function returns the hyperbolic sine of a complex number. For example, given 1+π/2i as input, the function returns -4.10319E-15 + 1.543080635i as output.
=IMSINH(COMPLEX(1, PI()/2)) // returns -4.10319E-15 + 1.543080635i...Read moreThe Excel IMCSC function returns the cosecant of a complex number. For example, given "4+3i" as input, the function returns "-0.075489833+0.064877471i" as output.
=IMCSC("4+3i") // returns -0.075489833+0.064877471i
In...Read more
The Excel IMLOG2 function returns the base-2 logarithm of a complex number. For example, given the "-4i" input, the function returns "2-2.2661800709136i" as output.
=IMLOG2("0-4i") // returns 2 - 2.2661800709136i
The real part of the output...Read more
The Excel IMLOG10 function returns the base-10 logarithm of a complex number. For example, given the number "0-100i" as input, the function returns "2-0.682188176920921i" as output.
=IMLOG10("0-100i") // returns 2 - 0.682188176920921i
The...Read more
The Excel IMEXP function returns the exponential of a complex number. For example, given "0+πi" as input, the function returns "-1+3.23108914886517E-15i" as output. The output is essentially -1, but due to floating point precision, it contains a very small imaginary component.
...Read more
The Excel IMLN function returns the natural logarithm of a complex number. For example, given the complex number "3+4i" as input, the function returns the logarithm of the complex number.
=IMLN(COMPLEX(3,4)) // returns 1.6094379124341 + 0.927295218001612i...Read moreThe Excel ASINH function returns the inverse hyperbolic sine of a number. Given one as input, the function returns 0.881373587 as output.
=ASINH(1) // returns 0.881373587
The inverse hyperbolic sine returns the...Read more
The Excel IMSEC function returns the secant of a complex number. For example, given "4+3i" as input the function returns "-0.065294028-0.07522496i" as output.
=IMSEC("4+3i") // returns -0.065294028-0.07522496i
In math,...Read more
The Excel IMCOT function returns the cotangent of a complex number. For example, given "3+4i" as input, the function returns "-0.000187588-1.000644392i" as output.
=IMCOT("3+4i") // returns -0.000187588-1.000644392i
The Excel IMTAN function returns the tangent of a complex number. For example, given the complex number "3+4i" as input, the function returns "-0.000187346+0.999355987i"
=IMTAN("3+4i") // returns -0.000187346+0.999355987i