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
The Excel IMSIN function returns the sine of a complex number. For instance, given "1+1i" as input, the function returns the complex number equal to the sine of the input.
=IMSIN("1+1i") // returns 1.29845758141598+0.634963914784736i
Given...Read more
The Excel IMCOS function returns the cosine of a complex number. For instance, given “1 + 1i” as input, the function returns a complex number equal to the cosine of the input.
=IMCOS(COMPLEX(1,1)) // returns 0.833730025131149-0.988897705762865i...Read more