IMSEC

Formulas / IMSEC
Calculate the secant of a complex number.

=IMSEC(inumber)

Examples

IMSEC( 0.5 )
The function returns the inverse secant of a number or complex number. For example, this formula returns 1.13949392732455.
IMSEC( "3+0.5i" )
This example returns 2-i which is -0.89191317974033 + 0.0587531781817398i.
IMSEC( A3 )
The function can also be used with a cell reference. For example, this formula returns -0.41314934426694 - 0.687527438655479i.
IMSEC( COMPLEX( 1, -1 ) )
The function can be used to return the inverse secant of a complex number. Such as above, where it returns 0.498337030555187 - 0.591083841721045i.

The IMSEC function, introduced in Excel 2013, calculates the secant of a complex number, which is the inverse of the cosine of the complex number.

What is the IMSEC function?

The IMSEC function calculates the secant of a complex number.

What does the IMSEC function do?

The IMSEC function takes a complex number as its argument and returns the secant of that number.

What arguments does the IMSEC function take?

The IMSEC function takes a single complex number as its argument.

What type of data does the IMSEC function return?

The IMSEC function returns a single complex number.

What is the syntax for using the IMSEC function?

The syntax for using the IMSEC function is as follows: IMSEC().

Are there any examples of using the IMSEC function?

Yes, here are some examples of using the IMSEC function: