IMSEC

IMSEC(inumber)

Returns the 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 IMCSC function to return the cosecant ratio of a complex number.
* You can use the IMCOT function to return the cotangent ratio of a complex number.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* You can use the IMCOS function to return the cosine ratio of a complex number.
* You can use the IMSIN function to return the sine ratio of a complex number.
* You can use the IMTAN function to return the tangent ratio 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=IMSEC("3+4i") = -0.0362534969158689+0.00516434460775318i
2=IMSEC("2i") = 0.266
3=IMSEC("2") = -2.403
4=TEXT(IMSEC("2"), "0.000") = -2.403
5=IMSEC("text") = #NUM!

1 - What is the secant ratio of the complex number, 4+3i.

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