Documentation/Calc Functions/IMSEC

Function name:
IMSEC

Category:
Add-in

Summary:
Calculates the trigonometric secant of a complex number. The secant is the reciprocal of the cosine.

Syntax:
IMSEC(ComplexNumber)

Returns:
Returns a text string giving the complex number that is the secant of the complex number passed as argument.

Arguments:
ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, whose secant is to be determined. a and b are real numbers.


 * If ComplexNumber does not have an imaginary part (b equal to 0), the real part can be passed to IMSEC as a number rather than a string.
 * If ComplexNumber is not a valid complex number, IMSEC reports an invalid argument error (Err:502).

Details specific to IMSEC function
For a complex number of the form a+bi, IMSEC implements the following equation: However, IMSEC determines if b=0 and in this case simply returns 1/cos(a).

Related LibreOffice functions:
IMCOS

IMCOT

IMCSC

IMSIN

IMTAN

ODF standard:
Section 6.8.22, part 2

Equivalent Excel functions:
IMSEC