IMSECH function
Returns the hyperbolic secant of a complex number. The hyperbolic secant of a complex number can be expressed by:
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)
This function is available since Office 3.6.
Syntax
IMSECH(Complex-number)
Complex-number is a complex number whose hyperbolic 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.
Examples
=IMSECH("4-3i")
returns -0.0362534969158689+0.00516434460775318i.
=IMSECH(2)
returns 0.26580222883408 as a string. The imaginary part is equal to zero, so it is not displayed in the result.
Open file with example:
