Purpose
Return value
Syntax
=IMSEC(complex_num)
- complex_num - The complex number in the form "x+yi".
How to use
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.
=IMSEC("4+3i") // returns -0.065294028-0.07522496i
Explanation
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.
=IMDIV(COMPLEX(1,0),IMCOS(z)) // equivalent to IMSEC(z)