IMSEC function

Returns the secant of a complex number. The secant of a complex number can be expressed by:

sec(a+bi)=1/cos(a+bi)

The result is presented in the string format and has the character "i" or "j" as an imaginary unit.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

Syntax

IMSEC(Complex_number)

Complex_number is a complex number whose secant needs to be calculated.

A complex number is a string expression resulting in the form "a+bi" or "a+bj", where a and b are numbers.
If the complex number is actually a real number (b=0), then it can be either a string expression or a number value.

The function always returns a string representing a complex number.
If the result is a complex number with one of its parts (a or b) equal to zero, that part is not displayed.

Приклади

=IMSEC("4-3i")
returns -0.0652940278579471+0.0752249603027732i.

=IMSEC(2)
returns -2.40299796172238 as a string. The imaginary part is equal to zero, so it is not displayed in the result.

Відкрийте файл з прикладом:

IMCSC, IMCSCH, IMSECH