The Excel Imsec function returns the secant of a supplied complex number
Syntax:= IMSEC(inumber)
The IMSEC function syntax has the following arguments:
 Inumber Required. A complex number for which you want the secant
Example: Let’s look at some Excel IMSEC function examples and explore how to use the IMSEC function as a worksheet function in Microsoft Excel:
Syntax: =IMSEC(A2)
Result:
Based on the Excel spreadsheet above, the following IMSEC examples would return:
Syntax: =IMSEC(A3)
Result: 0.1511762982655770.226973675393722i
Syntax: =IMSEC(A4)
Result: 0.000236988851448577+0.0000689652209600185i
Syntax: =IMSEC(A5)
Result: 0.6111085641552320.347676660710496i
Syntax: =IMSEC(A6)
Result: 0.06529402785794710.0752249603027732i
Syntax: =IMSEC(A7)
Result: 7.5502690885582E11
Syntax: =IMSEC(A8)
Result: 0.0906525837924345+0.0408008103994384i
Syntax: =IMSEC(A9)
Result: 0.008808948409770890.0101982619011619i
Syntax: =IMSEC(A10)
Result: 0.0000320729536644849+9.33342808715424E06i
Syntax: =IMSEC(A11)
Result: 3.48576140854289E06+0.0000117836687488848i
Syntax: =IMSEC(A12)
Result: 3.45891064328198E09+2.24262216678535E09j
Syntax: =IMSEC(A13)
Result: 6.26535191499983E1059.9503379623384E105i
Note:
 Use COMPLEX to convert real and imaginary coefficients into a complex number.
 If inumber is a value that is not in the x+yi or x+yj text format, IMSEC returns the #NUM! error value.

If inumber is a logical value, IMSEC returns the #VALUE! error value