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.151176298265577-0.226973675393722i
Syntax: =IMSEC(A4)
Result: 0.000236988851448577+0.0000689652209600185i
Syntax: =IMSEC(A5)
Result: -0.611108564155232-0.347676660710496i
Syntax: =IMSEC(A6)
Result: -0.0652940278579471-0.0752249603027732i
Syntax: =IMSEC(A7)
Result: 7.5502690885582E-11
Syntax: =IMSEC(A8)
Result: -0.0906525837924345+0.0408008103994384i
Syntax: =IMSEC(A9)
Result: -0.00880894840977089-0.0101982619011619i
Syntax: =IMSEC(A10)
Result: 0.0000320729536644849+9.33342808715424E-06i
Syntax: =IMSEC(A11)
Result: 3.48576140854289E-06+0.0000117836687488848i
Syntax: =IMSEC(A12)
Result: -3.45891064328198E-09+2.24262216678535E-09j
Syntax: =IMSEC(A13)
Result: -6.26535191499983E-105-9.9503379623384E-105i
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
