IMSEC
Formulas / IMSECCalculate the secant of a complex number.
IMSEC(inumber)
- inumber - required complex number
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.
Summary
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.
- The IMSEC function was introduced in Excel 2013.
- It calculates the secant of a complex number when passed as an argument.
Frequently Asked Questions
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:
- IMSEC(1+2i) returns 0.5722 + 0.7493i
- IMSEC(3-4i) returns 0.8459 - 0.5346i
- IMSEC(-5+6i) returns 0.8422 + 0.5389i
