How to use IMSEC Function in Excel

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:

IMSEC Function - How to use IMSEC Function in Excel

Syntax:  =IMSEC(A2)

Result:

IMSEC Function in Excel - How to use IMSEC Function in Excel

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

READ:  How to use HEX2DEC Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *