IMSECH

IMSECH(inumber)

Returns the hyperbolic secant ratio of a complex number.

inumberThe complex number.

REMARKS
* If "inumber" is not in the form x + yi or x + yj, then #NUM! is returned.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the SEC function to return the secant ratio of an angle.
* You can use the IMSEC function to return the secant ratio of a complex number.
* You can use the IMCOSH function to return the hyperbolic cosine of a complex number.
* You can use the IMSINH function to return the hyperbolic sine of a complex number.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* You can use the IMCSCH function to return the hyperbolic cosecant of a complex number.
* You can use the TEXT function to return the number as a formatted text string.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=IMSECH("3+4i") = -0.065294027857947+0.0752249603027732i
2=IMSECH("2i") = -2.403
3=IMSECH("2") = 0.266
4=TEXT(IMSECH("2"), "0.000") = 0.266
5=IMSECH("text") = #NUM!


© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top