Purpose
Return value
Syntax
=IMSEC(complex_num)
- complex_num - The complex number in the form “x+yi”.
Using the IMSEC function
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)
Purpose
Return value
Syntax
=IMSECH(complex_num)
- complex_num - The number to get the inverse hyperbolic secant of.
Using the IMSECH function
The Excel IMSECH function returns the hyperbolic secant of a complex number. Given “1+1.5707963267949i” as input, the function returns “-3.9E-15-0.85092i” as output.
=IMSECH(COMPLEX(1, PI()/2)) // returns -3.9E-15-0.85092i
Explanation
The complex hyperbolic secant function is the reciprocal of the complex hyperbolic sine function.
In Excel, the function’s output is equivalent to the following formula.
=IMDIV(1,IMCOSH(z)) // equivalent to IMSECH(z)
