Summary

The Excel IMSEC function returns the secant of a complex number. The secant is the reciprocal of the complex cosine function.

Purpose 

Get secant of complex number

Return value 

The secant of the complex number.

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.

The complex secant function definition.

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)
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.