IMSEC

Get secant of complex number

Syntax

EXCEL Copy

=IMSEC(complex_num)

Arguments

Parameter	Description
complex_num	The complex number in the form "x+yi".

Return Value

The secant of the complex number.

Details

The Excel IMSEC function returns the secant of a complex number. For example, given "4+3i" as input the function returns "-0.065294028-0.07522496i" as output. In math, the complex secant function is the reciprocal of the complex cosine function. In Excel, the output of the complex secant function is equivalent to the following formula.

Examples

Example 1

The Excel IMSEC function returns the secant of a complex number. For example, given "4+3i" as input the function returns "-0.065294028-0.07522496i" as

EXCEL Copy

=IMSEC("4+3i") // returns -0.065294028-0.07522496i

Explanation

In Excel, the output of the complex secant function is equivalent to the following formula.

EXCEL Copy

=IMDIV(COMPLEX(1,0),IMCOS(z)) // equivalent to IMSEC(z)

See Also

IMCOS